Topics
Started by
Posts
Last post
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
I have a table like this: declare @T table (cid int, model char(4), shipdate datetime, quantity …
1 replies
A while back, i think in March, i posted a question on how to search for any word in any order and …
7 replies
Viewing 15 topics - 6,436 through 6,450 (of 12,232 total)
You must be logged in to create new topics.