We are getting there...your ddl doesn't actually run as is.

Try this for the Fact table

create table FACT

(

ID int identity(1,1),

OrderID INT,

relNum int,

DDATe DATE,

BGallons numeric (14,3),

GGallons numeric (14,3),

NGallons numeric (14,3),

MAXBolTime...

chinni_16 (9/28/2012)

---

I need to display time with timezone and date when executing the report.

I was trying with format but I did get the desired results.

It has to be displayed like...

Where are you getting this from? There have...

Yes there is. The answer starts by reading the first link in my signature.

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...