Add USE statement to a proc (using DSQL):

CREATE PROC xxx AS

BEGIN

DECLARE @sql varchar(100)='USE tempdb; SELECT * FROM sys.database_files;'

EXEC(@sql);

SET @sql='USE master; SELECT * FROM sys.database_files;'

EXEC(@sql);

END

You can also accomplish this using the...

I can't speak to TVPs but I use this technique to create a default value in stored procedures and functions have seen it used quite often.

I have always been...

Great article Dwain! It also inspired me to read the N-Tuple article which I liked.

It’s almost a shame (not really! J) that I no longer support Accounting applications because...

NP. 🙂

Edit: misread ddl. Said something stupid.

I tried to solve this and failed. Well done Dwain C.

There are some nuances I wont cover here but should work or at least get you started.

To export a query from SQL Server to comma delimited CSV file

1) Right-click...

On the other side... I have never run REPAIR_ALLOW_DATA_LOSS.

This is not the most elegant or optimized approach but this will get you the result set that you are looking for...

--Parameter

DECLARE @topMonth int=3;

--if a valid month is not...

Thanks for the post dwain. That's really odd too; I would never think to...

Another way:

DECLARE @spitme TABLE (Item varchar(40));

INSERT @spitme VALUES ('HEYE-B Euro-IPA 69793'), ('HEYE-B RFE-IPA 70940');

SELECT SUBSTRING(Item, CHARINDEX(' ',Item)+1, LEN(Item)-(CHARINDEX(' ',Item)+CHARINDEX(' ',REVERSE(Item))))

FROM @spitme

Fun.

Using Jeff Moden's splitter[/url] you can do this...

DECLARE @spitme TABLE (Item varchar(40));

INSERT @spitme VALUES ('HEYE-B Euro-IPA 69793'), ('HEYE-B RFE-IPA 70940');

SELECT s.Item

FROM @spitme val

CROSS APPLY test.[dbo].[DelimitedSplit8K](val.Item,' ') s

WHERE ItemNumber = 2

Thanks Gail.

Your typo messed me up too...

You can also try:

;WITH x AS

(SELECT ID, Stat, StatDate

FROM #Apps

WHERE Stat='AppRec' AND StatDate >= '2012-12-01' )

SELECT ID, Stat, StatDate

FROM #Apps

WHERE ID...

zilla (12/17/2012)

---

I have a sub query within my IF statement that evaluates to one single number that I am using for a comparison operator. I am thinking there is something...

In case anyone was curious - the line in the Ben Gan book I was referring to is:

The SQL Server documentation indicates that not terminating T-SQL statements with a semicolon...