Thanks.

Questions from a newbie that's only been scripting queries for 2+ years:

You have it set up for deltas that are in table 2 that are not in table 1, to...

Are there any examples out there that can export data from a query into a text file using BIML? I am searching the interweb and cannot find any specifics...

Cool. I thought by looking at the Stairway series that this feature was added only to 2012.

Unfortunately, we only have 2008. I see the Stairway series for BIMS in 2012. Unless you can do something similar in 2008 that I do not know exists....

To add more to this. I heard that the bcp is kluged. It works fast, but it is ancient technology. So I was wondering if there was...

The temp table had 114 rows, why would it stop at 54?

I tried creating a table to do the same thing, but got the same error.

I need to populate the table, and then view the results.

Any help is appreciated.

Thanks,

Joe

Here it is. Thanks for helping:

IF object_id('tempdb..#tmptbl1') Is not null

drop table #tmptbl1

IF object_id('tempdb..#tmptbl2') Is not null

drop table #tmptbl2

-- load yes information into temp tbl

select ltrim(rtrim(table_name))as table_name,

case when AO...

So if this is the case, is there any way around the dynamic SQL? Thanks.

Actually, i cannot provide the code. Let me see what I can do with a do while loop.

Thanks,

In my select @SQL statement, I needed to put extra single quotes around the variable name. In this case: '''+@tablename+'''

Now my problem is I cannot select from the...

Figured it out. Thanks for your help.

I guess more information on what I'm trying to get would help.

The table we have actually has the counts, but we have multiple sources. The cursor gets the table...

This may help. What we do is a daily ETL and the tables created. Then we create a table where we send the table name and the record...