Hello,

You can use BCP command with xp_cmdshell for your requirement

Please check the tutorial for a sample case at http://www.kodyaz.com/articles/sql-output-to-file-using-sql-server-bcp-command.aspx

Here is a sample

DECLARE @s-2 nvarchar(4000)

SET @s-2 =...

Were you able to find why it creates emails so frequent?

I also used the BCP command with sp_executesql but I used sp_helptext in order to get sp code

http://www.kodyaz.com/t-sql/bcp-and-sp_helptext-to-script-store-procedures-into-seperate-files.aspx

But using the management views seems to be a better way of doing...

I remember I read on a blog post where some statistics were also gathered, the CLR function had better performance values

So I agree there are different ways and methods, but...

What you are asking for is split function

You can find samples on the web if you search with that term

Here is some

http://www.kodyaz.com/articles/sql-server-string-split-tsql-clr-function-sample.aspx

http://www.kodyaz.com/articles/sql-server-t-sql-split-function.aspx

http://www.kodyaz.com/articles/t-sql-convert-split-delimeted-string-as-rows-using-xml.aspx

Hello,

This script uses indexes to count the rows of a table instead of

SELECT count(*) FROM tablename

You can find a similar one here : http://www.kodyaz.com/articles/sql-rowcount-using-sql-server-system-view-sys-partitions.aspx

It seems to be no magic...

Hello Scott,

The new release, CTP3 has renderers for Excel versions 2003 and 2007

Probably they'll successfully export to these previous versions of Excel

Hi hawaiian,

Can you try following code

select

isnull(tt.custid, t.custid) custid,

t.custid2,

NAME = CASE when t.MatchField = 'NAME' then 'Y' else 'N' end,

DLN = CASE when t.MatchField = 'CITY' then 'Y' else 'N'...

Hello,

You can check delete duplicates rows using Row_Number() with Partition By clause

If you have identical rows in the table, you can also refer to methods mentioned at http://www.kodyaz.com/articles/delete-duplicate-records-rows-in-a-table.aspx

But the main...

Hello Smither,

If I don't understand wrong you want top 1 post for each discussion.

If so you can use SQL ROW_NUMBER with Partition By Clause

There is a sample at the above...

Hello,

I guess the problem is where you select the column names for pivot

I believe it will solve the problem if you use DISTINCT

Please refer to SQL dynamic pivot table example...

Hello,

These are objects from msdb database.

If you go to MSDB system database and browse the system tables node, you will see a list of table whose names are starting with...

Hello,

While creating dynamic pivot table, in the code part where column names are generated, you can use a where criteria preventing null values to be displayed as column header.

If you...

Great! Congradulations.

Hi,

The sys.partitions table can be used for records count in a table.

You can check article for more samples and sql scripts on SQL RowCount using sys.partitions

Using sys.partitions view is actually...