When Starship Troopers first came out, I wanted to see it, since i had read the book a long time ago...

took my kids to see it when they were 8...

here is a simple model that might help: take a look a this thread on a similar subject, where limits were needed to prevent connections from anywhere but the "right"...

it seems to me that unless you want the name and phone number fields to be null, you have to join to another table (by ID?) to get those other...

The original poster says he has installed SQL server, but cannot connect via SQL Server Management Studio. He also wants to learn BI, but is just getting...

Please don't crosspost. It just wastes people's time and fragments replies.

(cross posting is asking the same question multiple times in different forums)

By checking Recent Posts>>Posts Added Today

other forum...

Not enough information, my friend; remember we can't see the query that you are refering in your question...you'll need to show us the query you started with, so we can...

I have this snippets saved which might help; it's using a pair of loops table to strip out any comments , so you can then search just the remaining proc...

it depends on the source.

any SQL statement that features a FROM Clause can optionally have an INTO NEWTABLENAME in it.

so the trick is to wrap BULK INSERT so it has...

can you create a couple of views that selects from each of the linked tables, and then grant the AD group select on the view?

that's how I've done it in...

each destination table needs a separate insert command... so you'll use a WHERE statement to select/filter what goes to each server, instead of a case statement

case statement in SQL is...

is that characters 10 thru 20 of the whole file, or 10 thru 20 for each row/line in the file? so if the file has 120 lines, you need a...

what specific error do you get returned?

well, here's a simple procedure that will return a table with the definitions of just the view/proc/function objects that begin with "KLL" in the correct dependancy order.

you could then...

i think you want something more like this: the field cannot be trimmed to equal whitespace, and must have at least a letter or number in it

ALTER TABLE [dbo].[IntNotes] WITH...

Synonyms might fit the task at hand, but a synonym points to an object, not a part of a name.

for example, say your proc is looking for a specific 3...