Topics
Started by
Posts
Last post
I have a table as follows: id name value 1 name1 val1 1 name2 val2 1 name3 val1 2 nam…
2 replies
I need to drop all foreign key references prior to truncating all the tables and transfering in the…
4 replies
Hi, I have the following script segment which is failing: CREATE TABLE #LatLong (Latitude DECIMAL…
9 replies
Hi, Some background: I have a school. School have classrooms. Classrooms are divided into various s…
1 replies
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
Viewing 15 topics - 11,671 through 11,685 (of 12,234 total)
You must be logged in to create new topics.