Viewing 15 posts - 1 through 15 (of 93 total)
I found myself in the same situation and after reviewing many posts couldn't find a simple solution. Then by light bulb turned on.
This is what I did
1) I set...
April 3, 2012 at 9:07 am
SELECT TOP 10
Prod,
Acct,
TC,
SubmitRep1,
Percent1,
FROM
dbo.tbl_CYProcessedSales
WHERE
Proj IN (100,200)
AND Percent1 < 80
AND NOT SubmitRep3 = ''
AND Prod = 'RETA'
UNION
SELECT TOP 10
Prod,
Acct,
TC,
SubmitRep2,
Percent2,
FROM
dbo.tbl_CYProcessedSales
WHERE
Proj IN (100,200)
AND Percent1 < 80
AND NOT SubmitRep3 = ''
AND Prod =...
February 5, 2008 at 8:55 am
Check this out
Google this: sql to calculate next business day...you may find other approach.
November 29, 2007 at 6:08 am
The answer is in the Error Msg. & is boolean operator. Replace with + (plus) sign. Add logic to pad with zeros based on lenght when len is variable. If...
November 2, 2007 at 11:07 am
October 23, 2007 at 6:17 am
Try this
USE <dbname>;GRANT CONTROL SERVER TO <username];GO
Read here:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/7e880a5a-3bdc-491f-a167-7a9ed338be7f.htm
I understand now. This will not give you what want.
June 26, 2007 at 1:16 pm
Right Click on Databases
Select _Restore Database
Select radio button From Device, click on the elipsis (...), find the .bak file
Select the Check box and in the text field on the top...
June 26, 2007 at 1:11 pm
I will assume you are exporting a table. Script the table to Select, add a column with the datalength of the memo field, sort by that field in descend order. Export...
June 14, 2007 at 11:21 am
Read here:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/d76cd143-8db6-439d-928d-37c393c2783f.htm
validation | If this option is set to false, the default value, SQL Server checks for schema changes that have occurred since compilation in... |
June 4, 2007 at 11:02 am
From Management Studio go to Tools / Options Select Scripting and then Table and Views scripting Options. Set Script Defaults to True.
June 4, 2007 at 10:49 am
I don't know if it is possible to script the custom XML type in SQL Express, but if you can do so. Make sure to change all the DB references...
June 1, 2007 at 12:02 pm
right click the linked server registration and update the Security to user/pass (with just read access if using it for Apps) and define the starting db. After that you can...
June 1, 2007 at 11:48 am
http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm
You can also load the list into a @temptable and join to it when building your @SQLCommand
June 1, 2007 at 11:38 am
Viewing 15 posts - 1 through 15 (of 93 total)