dweil (3/29/2012)

---

Here is the scenario.

I want to write a query to find out which employees have preformed a service on the weekend over a quarter period. They get one...

i would import it into msdb and try the job...

naravetlasri (3/29/2012)

---

Hi,

I am new to this SQL,and I am practicing some online examples where I got stuck with one of the excercise .

here is the Question

In which years was...

at my shop we had to track DB changes from one version of a product we use...

you almost never want the aggregate your creating in your group by. it basically gets rid of any aggregation.

no problem. self joins can get...

you might try "/n" for your row terminator. that seems to be what the first error is complaining about. after that the additional errors may be generated because...

i got this from the following link.

Snapshot replication distributes data exactly as it appears at a specific moment in time and does not monitor for updates to the data. When...

Triality (3/27/2012)

---

Hello -

I have a table with a bunch of sales orders from different channels (Example: Retail stores, online orders, other). I want to the output of my query...

djustice 20821 (3/27/2012)

---

This is the code that I used:

ALTER DATABASE DB

SET SINGLE_USER

WITH ROLLBACK IMMEDIATE

GO

DROP DATABASE db

GO

and the error that I got:

Msg 5064, Level 16, State 1, Line 1

Changes to...

SQLKnowItAll (3/27/2012)

---

Just guessing... but did you put the database into single user using the query window, then try to delete the database by right-clicking on it and selecting delete? (2...

with out DDL and sample data from the UserID table your populating your temp tables from it would be a little tough. This may work though:

SELECT u1.userID FROM Users...

njdevils39 (3/26/2012)

---

capn.hector (3/26/2012)

---

im amazed at your patience sean. im sitting here laughing. ill save you at least one time.

We need the DDL and sample data. im supprised...

im amazed at your patience sean. im sitting here laughing. ill save you at least one time.

We need the DDL and sample data. im supprised you are...

since no one has posted yet and im not seeing any other way than a loop (i am new at this) you can try this: load the file using...