Since there is not such thing as row beneath another row, I assume that you meant that you want the identity value that has 3 different values between it and...

For stored procedure you can check the column modify_date in sys.objects. Unfortunately with table it can be harder. If I remember correctly rebuild for the clustered index or...

Each index will cause an insert statement to be slower, because the operation will have to update the table and then the index. Without the index it needs to...

One simple way is to use a if block:

If @x=1

Select column1, column2, column3 from MyTable

Else

Select column4, column5, column6 from MyTable

If you insist of doing just one select statement, then...

It is very easy to create a small script that creates the table and insert the data into the table. Since it does save some time from anyone that...

One more way:-)

2 remarks before the discussion about the way to update your table:

1)Try not to use column names that are also reserved words in SQL Server. The column...

You can create a local procedure that activates the procedure in the second database, and let them use the local procedure, but if they'll look at the local's procedure code...

When you define a CTE, the select statement that uses the CTE has to come immidate after the CET's definition. In your code you use an if statement between...

Do you have the value NULL in column client_accountno? It seems that you have it. You have to take into account NULLs. Check the code bellow that...

IIF works on SQL Server 2012. I've written you an example in the other thread that you've opened (http://www.sqlservercentral.com/Forums/Topic1412915-1292-1.aspx?Update=1) because it has nothing to do with Reporting Services.

Adi

IIF is a function that is used to return a value. Just like other functions (for example getdate()), it can't be written on its own without setting it's value...

Since you posted this question also in SQL Server newbies under SQL Server 2008, I have a feeling that your question has nothing to do with Reporting Services. Can...

There is no column level or row level trigger. A trigger is defined according to the operation on the table, so you can have triggers for insert, update and...

As I wrote in the previous message - Lazywriter...

The automatic checkpoint that SQL Server issues is not the only mechanism that writes the data into the disk. If you issue manual checkpoint command, it will write the...