Topics
Started by
Posts
Last post
hi guys, i have been working using PIVOT for the first time, i am going to create a view with the f…
3 replies
use [TSQLTestServer] SELECT * INTO ##g_temp FROM OPENQUERY(LocalSQL, ' SELECT * FR…
6 replies
Hi, Suppose i have the following data set. C1 C2 C3 C4 a@…
4 replies
Hello I am having two table Table1 and table2. In table 1 there is a column called errcode which co…
21 replies
Good day, I've created a view witch contains the folowing line: ISNULL([SomeDB].[SomeOwner].[SomeT…
4 replies
I have a set of values in a temp table (stored procedure) I need to dense_rank but I do not have a…
13 replies
i have one table with the following scheema: Table1 ContractorID, OrganizationID, ContactID I have …
3 replies
Hi guys I have a table sitting in a database where I dont have permissions to create or save a tabl…
2 replies
Are there any performance differences between EXCEPT and NOT EXISTS? Currently, I'm using the follo…
10 replies
Hi All, I have created a stored procedure which takes two input parameters. I need the query withi…
8 replies
I have a collection of 5 columns on which I have created a UNIQUE constraint. I should have created…
5 replies
Ok, so ... all I'm looking to do is randomly generate teams of two based on employee name. I have 5…
8 replies
Hello All, My requirement is as follows: I want to pull TOP N records from a customer table order b…
6 replies
HI all, I found this code which works great and is fast. select Col1, (select col2 + ',' from @…
3 replies
Table 1 has 15,000 records and table 2 has 1.5 million records. My query works fine when I use less…
3 replies
Viewing 15 topics - 8,656 through 8,670 (of 12,230 total)
You must be logged in to create new topics.