Bol = books on line = SQL sever help . search for SSIS tutorials to get you started.

If you want a way for the client to run this...

Another way to do this would be to create a SSIS package that can extract the file and write to a csv file, you can even get the SSIS package...

liebesiech (9/10/2009)

---

I don't get it! Talking about relational models, where data is supposed to be denormalized, and not defining a primary key on a table? Of course on paper you...

Michael Valentine Jones (9/4/2009)

---

Do you mean that having Primary Keys makes it easier, or not...

It can make developing software a lot easier - this is probably the best reason

It looks like you need to do a join on the tables, though it is hard to tell with limited information.

Could you post the table structures, sample data and what...

Have a look at the job history there should be an error logged in there..

Damien (9/2/2009)

---

Thank you very much for the reply but on this query

select * from master..syscacheobjects

where objtype = 'ADHOC'

It has a field of sql but how will I know on when...

This can be done using a Linked server.

http://msdn.microsoft.com/en-us/library/aa213778(SQL.80).aspx

you then refer to the linked table using the four part naming convention linked_server_name.catalog.schema.object_name

gary.wood (8/28/2009)

---

Understood. I wish tSql had a native IsInteger...

But either way, a value like 'NG123' would fail the ISNUMERIC test, so I expected it to be filtered before the...

try evaluating isnumeric = 1 not 0

select key1, column1, cast(column1 as int) as cst from test1

where (isnumeric(column1) = 1)

From the description a query with group by and a top 25 would work ordered by count(*)

select top 25 Store_name, count(*)

from CallLog

Group By Store_name

Order by Count(*)

This is just a guess...

try using

sp_who2

it seems like this is a case of parameter sniffing where the optimiser wrongly guesses the parameters for the stored procedure.

http://www.sqlservercentral.com/blogs/ken_kaufman/archive/2007/11/28/3289.aspx

Or you can try the GUI way (if you have the default trace running)

Right Click Datase --> Reports --> Standard Reports --> Schema Changes History

I hope that you have a...