Or you could try this undocumented procedure.

exec Insert1000RowsInATableWithoutAnyLoop

Well now there are new rules to your issue. I would not...

Guras (9/28/2012)

---

I am trying to store the EST as CST , PST as CST.

The time value coming from the web application are in their local time zone but ned...

Guras (9/28/2012)

---

I have a web application where the users will be entering time based on the different time zones there are in e.g. EST, CST, MST,PST etc...

My server is in...

SQL_path (9/28/2012)

---

Sean Lange (9/28/2012)

---

Can you post the actual values for your string and the EXACT error message. I don't see anything that would cause an error but I don't really...

Can you post the actual values for your string and the EXACT error message. I don't see anything that would cause an error but I don't really know what the...

Not enough details to provide much of an answer. What is in @orders? What does the split function look like?

I would recommend using the splitter found in the article...

The problem is because you have a list of numbers and you are trying to compare that to a uniqueidentifier.

You insert this into a table.

('101038, 101039, 101040, 101044')

INSERT INTO @Tmp...

What you are describing is what is known as EAV (Entity Value Attribute). This is a horrible design in almost every sense of the word. There are a few cases...

Using the text right in your error message...

"Full Error Text

-----------------

SQL1031N The database directory cannot be found on the indicated file system.

Explanation: The system database directory or local database directory could...

Take a look at this article by Gail about catch-all queries. Your situation is not exactly the same but you can modify the logic presented to handle your complicated sorting...

jrichards54 (9/27/2012)

---

"Let me know if that code works for you. If not I can probably help tweak it into submission."

I have created a database in ACCESS and named it "ConnectionTest.mdb"...

There is no switch statement in t-sql which I suspect is why there are so many nested if-else conditions.

SQL_Loser (9/27/2012)

---

I have questions regarding foreign key and about parent-child relationship:

1.What is the purpose of self referential foreign keys ? or why do we create it?

2.In a many to...

Start with the first link in my signature.