Import Data from in a Table

Then do something like this

Declare @v_Query nvarchar(max) = ''

Select @v_Query = @v_Query + [ColName] +' ;'

from [Excel_Table]

EXEC sp_executesql @v_Query

@v_Query

this will execute your all queries...

nice question Igor. Thanks for sharing

WHERE 1=1

AND 1=1

AND NOT ('A' LIKE '%Z%'

AND J1.JRNAL_SRCE IN ('B/F',

...

[h3]1st Clause:[/h3]

CASE 1

WHEN 1 THEN 'A'

ELSE J1.AC_CODE

END

This code will always return 'A' , query can be write above syntax like this

CASE when 1= 1 then 'A' else...

WITH C

AS (

select 'Draft' as auditedAreaDescription, 'A23' as auditId

union select 'Activity1' as auditedAreaDescription, 'A24' as auditId

union select 'Activity2' as auditedAreaDescription, 'A24' as auditId

union select 'Demo' as auditedAreaDescription, 'A25' as...

doing select * from will always get you in trouble, it is a bad practice, you should always use

select columnName from to avoid this issue

try this http://stackoverflow.com/questions/4215979/problem-with-select-in-mysql-through-odbc-from-microsoft-sql-server

hope it helps

this link will help you to get subtotals and grand totals

http://www.sqlusa.com/bestpractices2005/subtotaltotalgrandtotal/

did you check store procedure execution time on the source server i-e how much time it takes to execute ?

Jeff Moden (2/17/2014)

---

twin.devil (2/17/2014)

---

you can check few things before joining these two tables

let say u have check number in table 1 that i-e "12012410"

and

you have check number in...

you can check few things before joining these two tables

let say u have check number in table 1 that i-e "12012410"

and

you have check number in table 2 that...

Sorry, i meant to say is "Script Component" instead of "script manager".

1st of all i totally agreed with Phil.

but most of the time ... they say ... there is no issue in it 😛

here are couple of things you can...

try this one

http://blog.hoegaerden.be/2012/08/04/displaying-checkboxes-in-an-ssrs-report/

is it a virtual server or a physical server ?

try this

The problem might be firewall, but more specifically the firewall rule for SQL SERVER.

The custom rule could be...

what error you are getting while connecting to 2012 instance.