Sep 9, 2012 · Is anybody able to tell me why the below SQL throws an error saying "Query execution failed for data set 'DashboardTable'. The isnull function requires 2 argument (s)."?

May 7, 2012 · isnull (number)?0:number i got that answer..but wat is that problem means my next run my source data null values i want to put that as 0 so while comparing old data and new …

Dec 23, 2010 · There is ISNull ( ) function in SQl.This IsNull ( ) will check the value,if it has Null we can set our own value instead of Null.

Jul 1, 2010 · I recently set up log shipping in SQL 2008 SP1 (Primary, Secondary, Monitor all have SP1). For several days the .trn files are copied and restored to my secondary server's …

Jul 30, 2020 · You can't concat numeric values, only string. For numeric use a simple calculation ;with data as (select 3030 as val union all select NULL union all select 9090) select 99990000 …

Feb 19, 2013 · I had similar routine request to write a FOR XML query result to a file. I created a clr proc that allows the ability to do this. The downside is that your organization must first allow …

Sep 10, 2015 · SELECT t1.name FROM table1 t1 LEFTJOIN table2 t2 ON t2.name = t1.name WHERE t2.name ISNULL

Dec 5, 2018 · In SQL Server 2008, is there a way to check the status of a job using T-SQL? I have tried several variations of the following but none of them seem to work: EXEC

Mar 23, 2012 · and many of the columns have only null values so i now we want to find out the list of all those columns which holds null values like col1 col2 col3 col4 null 1 Null Null Null 3 Null …

Dec 6, 2011 · See if you are getting the data after using LOWER function version of the expression provided earlier. Alternatively, provide some samples that include the word "Cross" …