Topics
Started by
Posts
Last post
I was wondering if I can contruct a stored procedure that can add a value to to resultset. In my ca…
13 replies
Hi, I'm trying to find a way to count columns which are not NULL or blank in a table and have hit a…
2 replies
I need a query where a record has to have the value CardOrKey="Card" or else no records will be ret…
2 replies
I have a DTS containg the following: 1.Execute SQLL task. 2. Text file source 3. transform datatas…
2 replies
I have a table like so: Name | ServerOS | Client | Domain ServerA, Win2k3, 1, NA ServerB, Win2k3, 1…
5 replies
What are the three options in SQL Server 2005 to rebuild indexes?
7 replies
REF: http://doc.ddart.net/mssql/sql70/create_2.htm I have a small database where I have PK and FK. …
23 replies
I have a bunch of tables joined via a SQL diagram (relationships). I need to truncate transaction t…
6 replies
hi using this forum and various other sources i have created the trigger below - which for the most…
8 replies
Hi This is driving me nuts. I've run the update command below to change the job status which is doe…
7 replies
In T-SQL, I was almost positive the double pipe ' || ' could be used to merge statements together, …
1 replies
I have two main tables and a connecting table that I want to join together. The first table is Cust…
8 replies
Hi, i know the syntax dateadd(month,3,datefield) which will add 3 months and you can only see one …
6 replies
[/code] :ENDIF; :IF Len(aOLD[1,K])>0; :IF Len(aNEW[1,K])<>Len(aOLD[1,K]); …
1 replies
I am new to sql server 2005 and I am wondering if you can suggest any alternatives to the sql I hav…
3 replies
Viewing 15 topics - 1,021 through 1,035 (of 2,735 total)
You must be logged in to create new topics.