in cases like this, i suggest not working around the error, but addressing the error head on: huge query that exceeds 4K or whatever.

instead of having the report pass a...

i'd go with doing it physically.

if you really want to automated it,

you might do it via xp_cmdShell and the MOV...

i use this snippet a lot; but it is centric to a single database, but i bet it gets you 90% there.

it assumes I KNOW the destination for the...

for me, mentally,

CROSS APPLY = INNER JOIN

and

OUTER APPLY = LEFT OUTER JOIN

so if anything is going to consume the results of the previous JOIN/CROSS (ie using the...

this is syntactically correct,, and gives you your start and end indicators, as a set base doperation.

is this more like what you are after?

SELECT cdsDescription,st.[1stPos],en.[2ndPos]

FROM tbCompdistances

CROSS APPLY(SELECT CHARINDEX(' ',cdsDescription) AS...

something like this is what i slapped together; does this look right?

UPDATE MyTarget

SET

MyTarget.[IsCurrent] ...

here's the article i have bookmarked from Paul Randal, as mentioned above.

http://www.sqlskills.com/blogs/paul/checkdb-from-every-angle-consistency-checking-options-for-a-vldb/

you can manipulate the results in powershell

[System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources() | SELECT ServerName | Format-Table -HideTableHeaders

man that's a classic pain point i've tripped over myself.

i'm very sure it has to do with permissions related to folders (virtual fodlers?) within SSRS.

go to the SSRS web site,...

ok, this worked pretty well for me;

you can expand this to use char/nchar if needed, but i left it as varchar/nvarchar, as that's all i'd ever use anyway.

no need to...

you are missing the FROM clause. you can't select a column name without it's table.

SpeedSkaterFan (11/30/2015)

---

Hi all,

I am trying to split (incorrect) cellcontents into smaller pieces.

If I use:

SELECT cdsDescription

...

you'll need to add the NULLIF function, i think:

,ROUND(( CAST(AeSubCount AS FLOAT) / CAST(NULLIF(SubCnt,0) AS FLOAT) ), 2) AS Rate

your error is your print statement, you cannot print a column's value.

you have to print something static or a variable like @mbrs_id...

gurvinderg (11/30/2015)

---

My SQL Azure database has a stored procedure that has the merge statement. When my database on Azure was updated to latest v12 update , this procedure started throwing...

Chirag# (11/30/2015)

---

Hello SSChampion

thanks a for your answer , from your query i can get the id but mail was not received in my inbox

also it is not...