you need to do two things;

you'll need a Tally Table so you have all the possible values for your comparison;

second , you have to get your data into a table,...

dtopicdragovic (8/25/2010)

---

Therefore, I guess for Countries Table if I have just a column CountryName I can set it as Primary Key. I don't need to create a new field CountryID....

my table is similar, where we have an ID, cityname,state;, witht he PK being on the identity column ID, but with a unique constraint on cityname,state; at least in the...

one of the options when you do a full backup is the "Copy Only Backup" command, which allows you to take a full backup without disrupting the existing trnasaction/differential backups...

i know SSIS is built for this, but I always end up using what i know well...like you suggest, i do it the way you describe: bulk insert into a...

i believe the error you are seeing is because the service MSDTC (Distributed Transaction Coordinator)

must be running on both servers in order to support the cross instance transaction; you'll need...

low hanging fruit, my friend; so easy i couldn't resist 😀

looks like all you are missing is the FROM clause:

update ct_user

set dbo.nt_name = [ct_users1$]._nt_name

FROM [ct_users1$]

where dbo.ct_user.name = dbo.[ct_users1$]._staffName

i've done something similar two differnet ways; i ended up making an application because i had more control;

you can get a list of servers several ways, form osql to using...

the devil is in the details, so "it depends"

this:

/*

DO SOME SQL LOGIC

*/

depedning on what that is doing, or going to do, you might not need a loop or tally table...

show us the script you are using...are you tal\king into consderation non-standard database names?

ie select * from [My Database With Spaces Or a Reserved Word].dbo.sys.objects?

you have to define a table with the proper columns before you call the procedure.

if your proc, which is using dynamic sql, returns a different number of columns depending on...

that would limit all connections, whether from your web app or form Management Studio; remember your web server will try too pool connections, so it'll be reusing some of...

Denesh Naidoo (8/23/2010)

---

Hi All,

Working on SQL Server 2005.

Have a query that has a WHERE clause as follows:

WHERE (Documents.Flags & 0x18)=0

Can someone please explain the & 0x18 part which I have...

monietamarind (8/23/2010)

---

I am trying to Connect To Database Engine. I was able to get connected before. But, I am not able to do so now. The SQL...