Topics
Started by
Posts
Last post
We have this script..it takes over an hour to run if I uncomment the code in the select. Runs great…
5 replies
Hi, I'm wanting to prevent updates to a certain table after the row has been committed to the datab…
17 replies
I do not want to reinvent the wheel, but I need to write a procedure that can be passed two table n…
26 replies
Hi... I have a table (fctTable), which references another table (refTable) that has a parent/child …
4 replies
I have a table (JeffTest) that has two fields (Encounter, DocType). How can I get the Encounter tha…
12 replies
Hi, I need your help on the following query that I want to build. I have a table with the following…
10 replies
I have a varchar column with data as 10/28/2011 11:47:55.686455 AM whats the best way to convert it…
16 replies
Hi, I have around 53 tables in my schema. Due to some business constraint , we have not implement o…
3 replies
I'll kind of explain the details next however i figured i'd put up the issue and desired output fir…
8 replies
Hi, Can PIVOT do the above function? I have the following table: SELECT [Column1] ,[C…
9 replies
I am surprised that the first set of statements work but the second set do not. Is this working as …
1 replies
Here is my sp, the error comes out at the first FETCH NEXT FROM c INTO Error: [highlight=#ffff11]C…
15 replies
Sure this is a simple, and probably stupid question but I need help with the following; I run the f…
3 replies
Ldate is varchar type, it contains values '11/02/01' and 'ZZZZZZ' I need record only if value is d…
3 replies
I knew before we upgraded there were changes to queries in the Order Clause. I fixed most (got me …
2 replies
Viewing 15 topics - 1,276 through 1,290 (of 12,234 total)
You must be logged in to create new topics.