Topics
Started by
Posts
Last post
I'm having trouble getting some summary cost details from joined tables in a linked server. I have…
14 replies
I am baffled by the difference in performance between the old and new version of this query. Could …
10 replies
Hi pals, I need small help. I have a table with data as follows. select * from test_data c1 c2 c3 -…
14 replies
I have a airport table with airportID as primary key. I have an AirRoute table which has startingAi…
1 replies
Hai, I have a table in one db and and I want to reference it into another table which is in some …
2 replies
how can i calculate sum for the Counts column the query is like this SELECT C1.ID, C1.Name, Count(*…
3 replies
Is it possible to join the result set of a stored proc with a table, without inserting the result s…
12 replies
Hai frns small help, I have a table called sample and i have the following requirement. i.e i need …
4 replies
I want to add one more column to the results of this query. Right now the results only show the las…
16 replies
Hi Item Table: TABLE01 IVIVINDX, IVIVOFIX, IVCOGSIX, IVSLSIDX, IVSLDSIX, IVSLRNIX, IVINUSIX, IVINSV…
4 replies
I am looking at the possibility of writing a trigger, which will fire on insert and assign each rec…
4 replies
Hello Does anyone know if it is possible to somehow assign the COMPUTE results into local variables…
3 replies
I need to run a query in all servers, but I can not write a cursor becuase It is to create a report…
7 replies
Does SQL evaluate both parts of an OR condition or does it stop when one condition is TRUE? For exa…
2 replies
So I was playing with the ISDATE function and scripted this: DECLARE@Datum2 datetime SET @Datum2 =…
2 replies
Viewing 15 topics - 11,176 through 11,190 (of 12,230 total)
You must be logged in to create new topics.