Thanks Jeff Moden,

That is a big ask from me, but still i will give it a go. But still i hope i am far from writing any good stored procedure...

Hi Teague Byrd and Jeff Moden

Thanks for taking time to put these functions and these will work without any doubt for EST or PST but

If i understood correctly what Teague Byrd...

is there any way we will know when will be the daylight saving time as we need to adjust the ustoffset for daylight saving time.

thanks

Hi Jeff Moden

Thanks for looking in to my problem.

This is perfect if the client wants to see the dates in their local time but these timezones are fixed for each...

Thanks for the reply. It is a web based application.

Thanks

this did the trick david.infact i tried with ISNUMERIC function and it did the trick too..

thanks very much..

thanks for the reply david

but it gives problem when you have names in the table

as some thing like 'view of john' it gives error as converting varchar to int

i have...

i am sorry i haven't explained the problem clearly

Resourceclasses

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

ResourceClassId      Name                    Type

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

1                          Resource Classes      6

2                          All Resources           5

3                          Set1                      5

4                          List of Resource       5

5                          Union                     6

6                          Intersect                7

7                          Intersection            7

8                          Union1                   6

Type...

Thanks Remi Gregoire

I am expecting the output in the follwing format

ResourceClassId  ResourceId

3                      1011

3                      1001

3                      1015

5                      1011

5                      1001

5                      1015

5                      1009

5                      1004

6                      1001

6                      1009

6                      1004

Remi Gregoire i am not against your tip as i am already using that one.

As john had given me a solution to create an empty table ,i had to make...

hmm.. karl that was not possible.

the table i am joining is actually existed in a different database.Depends on my condition i should use that table..As Remi Gregoire has already suggested to...

Hi Remi Gregoire,

Thanks  for the Query you have written for me

I like the idea you have suggested me to create a view that selects all the fields from all the...

Thanks for the reply Remi Gregoire

The solution you recommended is absolutely right if i have to retrieve data from one or two tables

But unfortunately i have to join several...

David,thanks for taking time to solve my problem..

What i did not understand is i have run the query in two Query analyzers.

I executed my query in first QA and it...

i did tested this in my QA using Tsql, for some reason it is locking only the Questions table

but not Answers

Is there anything to do with indexes or primary keys...