Bulk Insert into a staging table.

Use the "Quirky" update method to strip each row apart into it's parts.

If you can provide sample data, people on this web site will bend...

pvasudha (6/3/2009)

---

Thank you Jack.

But this does not work if i have more ids.

For each id its giving me all dates.But it should only give me max date within 5 days...

mathieu_cupryk (6/3/2009)

---

I am missing something in the following:

F EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].sprUpdateReOpenedTicket') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].sprUpdateReOpenedTicket

GO

CREATE PROCEDURE [dbo].sprUpdateReOpenedTicket

(

@ticketID int =...

Lynn,

I can't believe that I missed this article when it came out. This is a fantastic article that I've put into my briefcase.

Fantastic job.

SQL Server Magazine just published an article by Itzik Ben-Gan where under certain conditions, a cursor-based approach scales out better than a set based one. I'm curious as to others...

Leo (6/2/2009)

---

Here is how we coding in our ASP/Web application, we use web config file to open SQL connection from our Front End Server using 'sa'.

Do I need to...

greggoble2 (6/2/2009)

---

I don't want to transfer them. I want to script them out to a .sql file so that I could restore them if the server catches fire. ...

Adam Machanic (6/2/2009)

---

SSC is a major site, and each article gets thousands of hits. Most of the readers probably don't bother to look at the discussion at all, and of...

Do it in a job.

I think that you can also make an SSIS pkg to transfer logins, which would then be run, you guessed it, as a job.

To avoid adding duplicate records, you might want to look at using "where not exists ()" or "where not IN ()"

You might also be able to use the EXCEPT operator.

To...

Side note question here... how appropriate is it to mention being an Eagle Scout on your DBA resume?

GilaMonster (5/30/2009)

---

Yes, but if it does...

The thing that bugs me, that I don't really understand, is:

If I have a table:

CREATE TABLE dbo.TableA (

Col1 varchar(10),

Col2 varchar(10),

...

Not a problem... we all get to more learn, and it...

GilaMonster (5/29/2009)

---

My definition of 'catch-all' (for what it's worth) is a query that...