just a simple grouping is what i would use;

note how i put your data into CREATE and INSERT INTO so that others could use it as sample data? that's a...

it sounds like a network issue...maybe DNS/WINS?

at the end, it says the IP is 165.193.92.4. is that an IP Address on your network?

does your connection string use the name of...

if someone is on your network, they could put in a packet sniffer, and copy packets back and forth from a server to any machine. with some work, they could...

the rule of thimb I've heard around SSC is table variable is fine for 1000 rows or less, more than that it's recommended to use a temp table, and explicitly...

i like Florians idea; I'd suggest something like he says, showing top 500 or something,and then a message like "171,432 records match this criteria...click next to review the next 500"

well, bandwidth and local machines' capacity is going to be the limiting problems...download 10 million records locally, manipulate them in local client side memory, them send back changes to the...

that depends on the assignment your teacher gave you right?

the easiest is to simply use the built in wizards from SSMS: right click...Tasks..Import/Export.

Other options are to use the SSIS todo...

sql server management studio has that ability built in(right click on database...Tasks...Generate Scripts,

Also since you can sp_helptext any proc/view/function, you could do something like this as well:

SET NOCOUNT ON...

unless you have a trace already set up and running, you cannot find out who deleted data, and aside from that, will most likely NOT be able to recover data...

well, if you run the script below, it will read the registry and tell you teh listening port...

i duoubt this will work over a linked server, which is what i...

a bit xolumn is still an integer value...it's just limited to 0 or 1.

does that help? i assume your excel file has that value in one of the columns?

Florian, i used a smtp dll...not the built in. nowadays program that runs the job handleds it , but i've done it all in SQL as well.

so i might...

force of habit for me snuck into the code;

SET DATEFIRST allows you to decide what day of the week is your "start of the week"; when you are fiddling with...

yes exactly just a scheduled job for a stored proc that ran every minute....it looped thru every row in the table where a flag SentSuccessfully = 0; it was nothing...

ok two steps, here's how I find "this weeks" monday and friday:

SET DATEFIRST 1

SELECT

DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0) Monday,

DATEADD(wk,...