Topics
Started by
Posts
Last post
See the script. When passing @tname (written to simply be a nvarchar that holds names of tables) sp…
2 replies
i have 2 select queries i need to build my first query is select name from emp Kings wings sings t…
7 replies
Hey guys, been struggling with this one for a bit and about to head home, but does anyone know how …
27 replies
Hi, I am trying to figure out a way to ignore NULLS using the RANK() function. According to this ar…
11 replies
I've written a query which churns away for 20mins and then deliveres the data, however, whilst chur…
10 replies
Hi I just want to export the values in a one column table to a txt file. I would just go back to bc…
5 replies
---------------------------------------------------------------------------------------------------…
8 replies
Hi, Can anyone explain me how the triggers work? Scenario: I have created a Trigger on a table to c…
5 replies
Hello Guys.. I am using SQL 2005 and the following query does not return any data though actual dat…
15 replies
I have a table where one of its field is a datatype Identity(1,1) Table ( ID int PK Name var…
2 replies
The company does not want cross joins so how can I fix the following: ALTER PROCEDURE [dbo].[sprGet…
10 replies
I've this pivot query where I want to apply an order by clause. The order by works fine if the pivo…
9 replies
Hi I have a proc that has been running for ages on a sql 2000 machine and we have recently upgraded…
5 replies
Hello, is this piece of code OK or should I add something to it? Each customer can contain a city, …
9 replies
Hi I would like a trigger for update , if I change the Manager of a master Task (e.g. TaskID 1), th…
6 replies
Viewing 15 topics - 6,436 through 6,450 (of 12,234 total)
You must be logged in to create new topics.