Topics
Started by
Posts
Last post
Hi, i have a table that has 8 columns, updating into that table, but the parameters that are being …
3 replies
hi need help this is the orginal code by-Jeff Moden ------------------------------------- DECLARE @…
2 replies
By: midan1
I am writing a stored procedure that will invoke xp_cmdshell similiar to below: select @cmd_str = '…
2 replies
I have the following data, CustomerID EngID EngCount 1 A11 2…
60 replies
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
By: danprem
Viewing 15 topics - 11,176 through 11,190 (of 12,234 total)
You must be logged in to create new topics.