where's the query you are refering to? did you forget to paste it so we can help you?

here's a tested example;

I've created a spreadsheet that has the contents of sys.servers.

you can grab a copy of it here:

SysServers_Example.xlsx

and the code, assuming 64 bit SSQL 2008 with the 64...

BCP only does raw text files,...

here's an xp_cmdshell example, like John mentioned above.

the list of files, isntead of being a single file, can be a space delimited set uf multiple files.

--http://www.7-zip.org/download.html

--http://downloads.sourceforge.net/sevenzip/7za920.zip

--xp_cmdshell is limited to ONE...

Hybrid DBA

Accidental DBA

😀

ok, adding WITH SCHEMABINDING to my scalar function cuts half a second off of my performance, so it goes to 7.5 seconds or so instead of over 8 seconds.

DelimitedSplit8K...

ok Dwain, I love these performance tests.

here's a setup comparing my crappy scalar function to your solution.

the DelimitedSplit8K pivot was roughly 4x faster on a million rows: 8 seconds vs...

patelmohamad (10/16/2012)

---

Thanks Lowell for instant reply,

This is my predication, not the actual data

, actual data is differ from my Example

in my data it gives me lot of no's 1,2,3.......n or...

the trigger is using the base table, isntead of just the new rows that exist in the special virtual tables INSERTED AND DELETED

this will insert just the new rows:

CREATE TRIGGER...

patel i see what you are asking, but i don't see the data reflecting something that allows it to beswitched like that;

about all i can suggest is a UNION and...

it's a little tough with denormalized data;

ideally you'll want to change the schema if you can to store dates in date columns, and notes in a seperate column; but we...

where ISDATE(A) = 1

AND CONVERT(datetime,A) > DATEADD(dd,-7,Getdate()) --7 days? 8 days? what's minus one week for you?

--AND CONVERT(datetime,A) > DATEADD(ww,-1,Getdate()) --1 week?

you might want to buy a copy of developer so you can restore and test teh client backup, even if they are using enterprise only stuff like compression;

well it's a table of data now, so you can do your normal queries with group by and stuff like that.

here's a crappy group by example i just tested: like...

it's fairly easy.

first, doa SELECT * FROM sys.traces; you'll probably see traceid = 1(the default trace) plus any other traces you have created (2,3,4 etc)

select the trace id of...