Jeff Moden (6/20/2009)

---

Florian Reischl (6/20/2009)

---

If you don't know a Table or how to work with please search this site. You will find a really good article published by Jeff Moden...

Jeff Moden (6/20/2009)

---

Heh... Ok... Remember... you asked.:-)

Here's why... the original code looks like this (for example)....

[font="Courier New"]--===== Create and populate the Tally table on the fly

 SELECT TOP 1000000 --equates to more than 30 years of dates

        IDENTITY(INT,1,1) AS N

   INTO dbo.Tally

   FROM Master.dbo.SysColumns sc1,

        Master.dbo.SysColumns sc2

--===== Add a Primary Key to maximize performance

  ALTER TABLE dbo.Tally

    ADD CONSTRAINT PK_Tally_N 

        PRIMARY KEY CLUSTERED (N) WITH FILLFACTOR = 100

--===== Allow the general public to use it

  GRANT SELECT ON dbo.Tally TO PUBLIC[/font]

If I throw that code into a code window in the presence...

You can use a Tally table and CROSS APPLY to scan your text and split for your delimiter.

DECLARE @t TABLE (col1 varchar(10), col2 varchar(30));

INSERT INTO @t

...

bkirk (6/16/2009)

---

1) SSIS package using SQL Task and Script task to output file

2) turn on xp_cmdshell and write to file directly from T-SQL SP. However i'm concerned about security on...

There are some samples and tutorials on MSDN:

http://msdn.microsoft.com/en-us/library/ms160894.aspx

Some of the business cases they show are much better done in T-SQL but it shows how it works and explains the syntax.

Why?

Have a look for SQL Server Compact Edition:

http://www.microsoft.com/Sqlserver/2005/en/us/compact.aspx

It's made for embedded applications and mobile devices.

Great idea 😀

Just for fun - if RIGHT and CHARINDEX is prohibited but you are allowed to use a Tally table 😀

DECLARE @txt VARCHAR(20)

SELECT @txt = 'helloALL'

SELECT

...

In addition:

To help with performance issues an execution plan is always helpful. Maybe have a look to Gail's article "How to post Performance Problems":

http://www.sqlservercentral.com/articles/SQLServerCentral/66909

Hi Chris

You can use a inline sub-query to query the...

Click your name in any post. Select "View Member's Profile". Select "Show all posts by this member..." in "Personal Information"

Duplicate post...

http://www.sqlservercentral.com/Forums/Topic738685-338-1.aspx

If you want to test your technical skills try to answer questions on this site. Compare your answers with others and study the differences.

Check activity log