Viewing 15 posts - 2,656 through 2,670 (of 3,221 total)
Hoping that this is what you are looking for. Create a parameterized stored procedure and then call that procedure passing your input values. Note in the sample I...
January 31, 2009 at 9:31 am
Let me ask the obvious question:
What do you want to do if P1 = P2 ?
January 30, 2009 at 7:29 am
You may want to look at the CASE Function in BOL
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/658039ec-8dc2-4251-bc82-30ea23708cee.htm
In the lower portion of the page it shows how to use the CASE function to replace the IIF function...
January 29, 2009 at 6:10 pm
dglane
Is there a way to suppress the display of result sets?
vishal.gamji
Change result set mode to text
Changing to text output willl not suppres the display of result sets.
You can direct...
January 29, 2009 at 12:17 pm
Read Books On Line:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a87d0850-c670-4720-9ad5-6f5a22343ea8.htm where you will find the CONVERT function:
The following table shows the values for style that can be used for converting money or smallmoney to...
January 28, 2009 at 10:00 am
Sergiy when I run your T-SQL
declare @cn as varchar(2000)
select @cn = notes + char(13) + char(10) + resolution as Combined_Notes
...
January 27, 2009 at 6:21 pm
Best I could come up with does output the lines at the Top of the report but does NOT print lines between the report header and sub header:
set @output =...
January 27, 2009 at 12:10 pm
has maybe 100 - 200 changes a day at best.
When suggesting backups, backups based on the amount of data added, updated or deleted I should have said, if you...
January 27, 2009 at 8:08 am
In addition to other replies you will recieve let me say backups, backups, and more backups both the database and log files. Depending upon your amount of data change...
January 26, 2009 at 4:37 pm
Presuming that you are going to run the T-SQL statement in SSMS and direct the results to a file. Try this for a fixed row length:
SELECT LEFT(LEFT(SUBSTRING(Entry,1,24) + SPACE(30),30)+...
January 26, 2009 at 2:36 pm
Applying the Rownumber process to your data for example:
;with numbered as(SELECT rowno=row_number()
over (partition by Invoice, Item, Type order by Invoice),
Invoice,Item, Charge, type from Sales)
select *...
January 26, 2009 at 8:51 am
You asked for any ideas? Hopefully this might start your tbinking along a different track to a solution.
If this is new work, that is the column definition in your...
January 23, 2009 at 9:36 am
xp_FileExist and catch the reurtn code.
exec xp_fileexit 'c:\tst.txt', @catchcode Output
Watch the spelling in the exec line it is misspelled. It does exist in my SQL 2005.
January 21, 2009 at 10:11 am
Gsquared
Paul Nielsen's "SQL 2000 Bible"
Just hit Amazon and there are SQL 2005 Bible and SQL 2008 Bible (Pre-order due on Jun 22, 2009) by Paul Nielsen each priced at $31.49...
January 21, 2009 at 9:48 am
For a full understanding of the DBCC CHECKIDENT command read Books On Line (BOL) at:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/2c00ee51-2062-4e47-8b19-d90f524c6427.htm
paying particular attention to what might happed if you use the command improperly ...
If...
January 20, 2009 at 4:04 pm
Viewing 15 posts - 2,656 through 2,670 (of 3,221 total)