Hi

Seems that the JobCount column is not yet available for the ROW_NUMBER order within the SELECT clause.What about a second CTE?

DECLARE @Company TABLE (CompanyId INT, CompanyName VARCHAR(30))

DECLARE @Job TABLE (JobId...

Hi

syscomments is only available for backward compatibility. Try sys.sql_modules instead:

SELECT

OBJECT_NAME(object_id),

*

FROM sys.sql_modules

Greets

Flo

Hi Roy

Those procedures are usually not used directly from your code. They are called by your developers connection layer (OLEDB/ODBC/ADO). These are server side cursors. The server side cursors do...

Hi

Two possibilities:

1.) Create a dynamic SQL statement and execute it.

2.) Use a on-demand split and join the data instead of using an IN statement.

Greets

Flo

I tried Vista x64 on my new PC (no laptop) but the performance was awful.

Luckily my company gave me a Server 2008 x64 license. It's running perfect.

Paul White (5/13/2009)

There is no way I have been *that* good all year :angry:

Uncle...

One dollar for every time I misunderstood somebody...

Hi

Usually your application connects with windows credentials of the current connected user to connect to database.

If you want to use windows authentication but connect with another user you have to...

Hi Jan

IMHO 1 MB growth is almost never suggestive. I didn't say that it should always be initialized with gigabytes or even terabytes. This depends on the business case.

I think...

Hi

You don't have to specify username/password in this case. Here an example connection-string:

This works for OLEDB and SQL Server Client:

"Data Source=YourServer;Initial Catalog=YourDb;Integrated Security=SSPI;"

If you use SQL Server Client you can...

Send me a link when it's online!

UMG, did you try the cursor?

Greets

Flo

brussels sprouts and aubergines...

:sick:

Jeff and the meat... *sigh*

😀

Hi

You can use a sub-query in your SELECT clause using a Tally (aka Numbers) table to find the positions. Use FOR XML PATH to concatenate the positions and SUBSTRING to...