Topics
Started by
Posts
Last post
Is there any query to get the tables that are to be optimizated (defrag, reindex, update stats). Th…
3 replies
Hi all, I have a table with ten thousands of rows that looks something like this: CREATE TABLE #te…
3 replies
I am trying to show the total number of invoices per customer, and the total purchase amounts by cu…
11 replies
I have the following data in a query: CREATE TABLE EmpHours ( EMP_ID INT NULL, EMP_DATE_WORKED VARC…
8 replies
I have an employee table where in many instances the same ssn is listed for the more than one emplo…
6 replies
Hi Everyone, SELECT GETDATE() result: 2012-01-25 09:44:25.777 Expected result: 20120125094425.777 o…
6 replies
Hi, I want to insert multiple number of rows in a table based on the number recorded in a column on…
15 replies
I have an import process where we receive US Zip and Canadian Postal Codes in the same field. We us…
11 replies
I've got a Prod system and Stage system I've fired off the same script on both systems. The prod bo…
3 replies
Hi All I feeling very odd to ask but i am really really very confused by this how to make order by …
13 replies
Anyone know of a good way to map out a db's tables and include all foreign keys and such other than…
3 replies
Hi Friends I have a issue which i am not aware bec myself getting surprise to it.. I have a where c…
4 replies
I am setting a db to SINGLE_USER mode in order to then rename some databases: -- Set single User al…
5 replies
Hi, Between a Year date range, I need following output Year_Num, Alphabet 1901, A 1902, B 1903, C …
2 replies
Hi, I have a product database from different brands their are 120 brands and 80,000 products each p…
4 replies
Viewing 15 topics - 6,706 through 6,720 (of 10,635 total)
You must be logged in to create new topics.