You need to learn that if you want to get the count of the rows the main option is to use "SELECT COUNT(*) FROM Table". You need to learn the...

I do, but I'm not...

I have to admit that the CROSS APPLY was because I went lazy and didn't change it for an INNER JOIN. Here's an alternative with additional columns that show how...

There's no need to loop through the table. You should post sample data in a way that we can just execute it and start working on it. I did it...

For one moment, forget about dynamic code. Try writing a static query that will do what you need.

When you're sure that you have the correct query, you can use the...

You don't need to create a table each time you need to query something. A SELECT will be enough.

Check the following articles:

COUNT(): http://msdn.microsoft.com/en-us/library/ms175997.aspx

QUOTENAME(): http://msdn.microsoft.com/en-us/library/ms176114.aspx

Dynamic SQL: http://www.mssqltips.com/sqlservertip/1160/execute-dynamic-sql-commands-in-sql-server/

No, I mean building the string. Something like this:

SELECT Top 1 'The table I need is ' + name + '. Now I can create a SELECT statement with it'

FROM...

You have posted your code 4 times. It's easy to understand even if it's showed as a quote. When posting, review that you're using the correct tags.

Follow the instructions in...

Your variable @MyRowCount will always return 1 or 0 because you're limiting the results.

You have a query that will return the name of the table. Using that value, build a...

dogramone (10/23/2014)

---

Just a thought, dynamic SQL, selecting the table names into a variable and loop through the resulting set of table names excecuting the count query for each.

conceptually ...

select the...

You don't need to read...

spaghettidba (10/23/2014)

---

ChrisM@Work (10/23/2014)

---

Without...

You don't need Pearl, you could use xp_cmdshell.

For inserting data, you could use pure T-SQL with BULK INSERT.

Below the post textbox, there's a section for Attachments. You can use that. 😉

(See the attached image)

Using sqlfiddle, I was able to test this:

WITH wos AS(

SELECT Id,

wo,

wodate,

...