How's this?

-- See how you start off by actually creating a table and then

-- inserting the data into it? Your doing this makes it a lot easier

-- for all...

beginner123 (3/23/2011)

---

I have to migrate data into the table which has dependencies. I want to insert data into parent table by using Insert Into command. If I do that will...

How about a parameterized query run in Excel? Make the first couple of rows be for entering the parameters (Start Date, End Date, etc.), then pass to the query to...

Be careful with that - you need to be on SQL 2008 SP1 CU5+ (I think...

... and opc.three beat me to it again... - even posted the same blog link!

Your solution is termed a "catch-all query". Read this blog post[/url] by MVP Gail Shaw on why you shouldn't do this... and why the dynamic sql is actually a better...

To continue on with what Sean has suggested, I would convert your table like this:

DECLARE @New_Table TABLE (

i_serial INT PRIMARY KEY CLUSTERED,

i_TrueState BIT);

WITH cte...

Check out this 4-part article[/url] by MVP Gail Shaw. (Read the other parts as well - VERY useful information!)

google "sp_help_revlogin" - the 2005 version is compatible with 2008.

It will script out the logins and passwords (hashed) where they can be run on another server.

Best_boy26 (3/20/2011)

---

Do you know any easy way to get the data for this from exisiting table and exisitng data to post as a sample... ? I mean from SQL Studio...

Set it up with windows authentication only, and set yourself as an administrator. After the install, go back and set the sa pwd (unchecking the boxes for checking strength, etc.),...

You can also utilize a "NOT IN" in the where clause.

crud... shouldn't have canceled going after not getting accepted to...

See the two articles referenced in my signature dealing with Cross-Tabs and Pivots - Parts 1 and 2.

I'm writing a QotD dealing with actions NOT logged - so:

1. Does anyone have some good things that people think are not logged, but actually are (table variables, truncate table...