Topics
Started by
Posts
Last post
Hi I have 2 tables InvoiceDetails and InvoiceSubDetails. (Master detail table) . For each InvoiceDe…
4 replies
Hi, I am using the following trigger but it seems to do the second update and not the first update.…
5 replies
I need to drop all foreign key references prior to truncating all the tables and transfering in the…
1 replies
Hi all - I have a tricky problem that I'm trying to solve, and not really getting anywhere. I…
10 replies
I have a qeury which pulls all customers with duplicate addresses and displays a concatenated, comm…
5 replies
I would like to calculate dates to return number of years and number of day's to look like this&nbs…
2 replies
Hi, I am trying to write a query that joins 3 tables and produces counts on multiple columns within…
4 replies
One of the optimization tips that I use is to do away with using temp tables and just use a derived…
1 replies
What would be the best approach to calculate and display the number of months and days in a given d…
2 replies
Hi , I need to transpose the column name to row( without using any function) ,can anybody…
4 replies
I want to select the values of a column and use those values as column headings create a resul…
3 replies
Hello what is the best way to calculate in a query the average age of the persons in a table, havin…
5 replies
I'm trying to create a sproc with the following t-sql: SET @sql = 'SELECT dbo.Programs.Program …
6 replies
I have a situation that is simlar to one described below. Two tables: Table byState ( state_…
6 replies
Hi: In MS SQL Server 2000 and below, I was able to save my own stored procedure template that would…
4 replies
Viewing 15 topics - 11,671 through 11,685 (of 12,230 total)
You must be logged in to create new topics.