That would be very bad desing. You should not do it in T-SQL.

As to achieve it you will need to write everything in dynamic SQL for no benefits at...

I think I've gave you everything you need to code it, but obviously you want solution ha?

After seconds of googling I've found http://wwp.greenwichmeantime.com/time-zone/usa/hawaii/time/

Where you can read that Hawaii Time...

davidsalazar01 (8/19/2011)

---

The Crystal Report server and the Database server are both in (Central Standard Time), but I keep hearing the developers and manager talk about the data we receive in...

Where are you going to use these columns and what kind of data will be under them?

If you want to return empty recordset with "columns" to the client application,...

Usually localisation should be performed on the client and not on the server.

Do you store your datetime in UTC? You will need to use DATEADD function and apply required...

Column headings where? And what will be displayed under them?

karthikeyan-444867 (8/19/2011)

---

...

is it possible to generate the sequence number without using ROW_NUMBER () ? I mean can i use your method to generate the sequence number based on id, acc....

karthikeyan-444867 (8/19/2011)

---

...

I feel little bit hard to grasp all your points.

what is the relationship between these two combination? could you please explain it?

...

I have compared the performance of your...

You are right it's all to do with binary math and magic of some numbers in binary represented in binary...

Jeff Moden (8/18/2011)

---

Just for grins, drop the view, recreate it as it is, and try again. It frequently doesn't do a bloody thing but it can save a huge...

Not at all...

It was because someone wanted to turn 1,2,3,4,5,6,7,8,... into 1,2,3,4,1,2,3,4,...

not 0,1,2,3,4,5,6,7,... into 0,1,2,3,4,5,6,7,......

Wrong syntax - too many brackets and wrong position of comma.

create table xxx

(UserName varchar(256) not null,

DBName varchar(256) not null,

InstanceName varchar(128) not null)

You are lucky man than J. Celko didn't see you last request, otherwise you would be asked to read his books and learn that you should not do this...

Is any problem with using temporary table/IDENTITY?...

When you've cleared the file, does search work for other noise words? If not the file you've changed is not the one used by sql server. What I'm trying to...