AJB:

3) I used sys.database_files in...

AndrewSQLDBA (1/9/2013)

---

Hello Everyone

I hope that everyone is having a very good day.

I need to write a query to select row counts, but this seems like a lot of scanning of...

Danzz (1/9/2013)

---

Thanks for your reply Alan

I tried couple of ways, It did not work out

create table ##permission_info (id int primary key identity, information varchar(8000))

insert...

Jacob Pressures (1/9/2013)

---

Ok thanks for the info. Right now I'm trying to avoid D-SQL until i learn more about it.

The TVP seems, at least in my head, like an alternative...

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