... providing that there is a presentation layer... 😉

Heh... "I sense a disturbance in the force..." 😛

Barry is absolutely correct... he and I both just went through a couple of such posts just this weekend alone... user posts...

By the way... the code in the "too small" code window looks like this...

[font="Courier New"]select v.* from #mytable v, ( select min(id) as firstidofstagnation from #mytable v, ( select min(id)...

This will do it... As always, details are in the comments...

--===== Supress the auto-display of rowcounts for appearance

SET NOCOUNT ON

--===== Create two test tables (table variables, in this...

p.s. That will work only up to 23:59:59... if you need to exceed 24 hours, post back... there's a way...

I don't know too much about SSRS, yet... but here's how to do it in T-SQL...

SELECT CONVERT(CHAR(8),DATEADD(ss,4818,0),108)

Replace the 4818...

balamurugan.ganesan (5/26/2008)

I need to load a csv file in to SQL 2005 which has comma within the data. How to load this I am fed up trying this:angry:

Some help on...

It cannot be...

It's much simpler to add a clustered index... doesn't have to be unique, you know? 😉

"Must look eye!"

No cursors, no loops, no RBAR, please... simple Group By will do...

SELECT ID,

PPN,

...

To all my fellow Americans, especially those who served with honor... Happy Memorial Day!

To all those currently in Service... THANK YOU! It's sometimes hard to remember why you're there......

Good approach, I think... my question would be, how do you find and change all the references to such a table? Now THAT would make for an interesting article....

So, delete the SA account just like any other account... just make sure that SOME account has SA privs.

Still, I'd rather get the users used to the idea of the...

One thing that you should be made aware of... Unless you're installing the Developer's Edition of SQL Server, it must run on a Windows Server.

Maybe yes, maybe no... the Bulk Insert has to meet certain requirements to NOT be logged. Check for "Recovery Model" in Books Online for more information on the recovery...