Getting Started with Adobe After Effects - Part 6: Motion Blur
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Friends

Request Friendship



Upload Image

34 years old
New Orleans, LA
Male

My Sections

Adam Haines
234 · 1% · 194

Adam Haines's Home

My name is Adam Haines.
  • Getting Started with SSRS (SQL Server Reporting Services)

    Adam Haines Liked 6 Years ago through Tutorials
    This tutorial will help you to get started with SQL Server Reporting Services (SSRS)...
    f5debug
    52 · 4% · 1176
  • SQL Server Interview Questions

    Adam Haines liked 6 Years ago through Interview Questions
    Interview questions and answers on various SQL Server areas such as Database Administration, TSQL Development, BI etc....
    Jacob Sebastian
    1 · 100% · 32235
  • Create an xml from a sampled values of a table

    Adam Haines Commented 7 Years ago through Ask
    <p>I thought about this too before  I posted the solution.  You may get better performance by breaking one or more of the CTE steps into a temp table, so the optimizer does not have to pay spool costs.  For example by loading the Interval...
    ioan ivanov
    888 · 0% · 33
  • Create an xml from a sampled values of a table

    Adam Haines Commented 7 Years ago through Ask
    <p>Hi,</p> <p>You will need some form of recursive element to get the groups, so I suggest a recursive CTE.  From there you can use SQL Server xml functionality.</p> <p>I dont remember the code to post TSQL So please forgive me :). Here is one po...
    ioan ivanov
    888 · 0% · 33
  • Create an xml from a sampled values of a table

    Adam Haines Accepted Answer 7 Years ago through ASK
    <p>Hi,</p> <p>You will need some form of recursive element to get the groups, so I suggest a recursive CTE.  From there you can use SQL Server xml functionality.</p> <p>I dont remember the code to post TSQL So please forgive me :). Here is one possi...
  • XQuery: Unable to resolve sql:variable('@variable'). The variable must be declared as a scalar TSQL variable.

    Adam Haines Commented 7 Years ago through Ask
    <p>Here is how you would combat xml fragments with identical data.</p> <p> </p> <pre class="brush: plain;">--Add Dummy entry to xml fragment for update --This is only need if any of your fragments has exactly matching data UPDATE tbl SET col.mo...
    sanjaybxl
    196 · 1% · 246
  • XQuery: Unable to resolve sql:variable('@variable'). The variable must be declared as a scalar TSQL variable.

    Adam Haines Commented 7 Years ago through Ask
    <p>You will have to pull out the fragment and replace the text.  You can do this with replace and xquery. I forgot to add that this solution is dependent on each of the region fragments containing different data.  If the data is identical spac...
    sanjaybxl
    196 · 1% · 246

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.