Case statement is not a flow control statement. It is a function that returns a value. In your code you are using it as a control statement that...

I don’t know why it changed the order of the records, but if it is important for you to get the data in a certain order, you can’t trust the...

You can use access as a front end. With Access you can attach tables from other databases. You user can grant your user only select permissions and he...

Check if you have the same set options in the SSMS window as the application has. Some of the set options can produce a different query plan.

Adi

In the text file that you attached you are using a typed XML. In your XML schema collection and in the XML it self you specify which namespace should...

Pleas use the URL in my signature and have a look how to post a question in a better way. As for your question. According to the...

You can run an if exists query on information_schema.rutines that checks if there is a stored procedure with a specific name, but I don’t think that you should. Stored...

maury.lemons (4/10/2009)

---

I see you reply and thanks for the information. I have one more question? couldn't you do the samethings by alter the log shipping scheduled job time whan the...

The additional code that you write has to come before the code that the log shipping wizard creates. It should look more or less like this:

Declare @dt datetime

Set @dt...

I’m sorry but I have a feeling that we don’t understand each other (maybe because English is the second language for both of us). Can you try and explain...

I’m not sure that you have to do it as a job. A job is a scheduled task. It is executed according to the time and date. ...

Case statement is a function that can have as a result only one value. You are trying the use the case statement as a control flow statement. Here...

Your query doesn’t match the XML structure that you showed us. My answer is based on the XML that you attached and not on your query. If the...

Pleas give us more details. Do you want to import it as an XML column or do you want each value to go into a column? If each...

You can do it with the row_number() function. Partition the data according to status column and order it by state column in descending order. Then you can take...