Viewing 15 posts - 871 through 885 (of 5,111 total)
in small bale weight column where 200 is coming ,there will come 0 and Mix Rummage weight will be 200..
From your expression ISNULL(SUM(i.weight),0)Small_Bale_weight in your CTE cte. You return...
June 30, 2019 at 10:53 am
there is not null weight in Probale table ...as it is coming in small bale weight
So what is the result set you're after here and why?
June 29, 2019 at 10:00 pm
What's wrong with the result? You told us it's wrong, but not why or what the correct result set is. The SQL is returning what has been written, but we...
June 29, 2019 at 4:57 pm
Use PRINT or SELECT to return the value of @SQL and then debug your dynamic statement. Then you can propagate that to your statement that generates the dynamic statement.
On a...
June 28, 2019 at 9:52 am
Thanks for your help, I had a quick read of the link, and unless my tired old eyes are deceiving me the method won't port parameters - and the...
June 27, 2019 at 3:19 pm
Afraid I'm very new to Admin of SSIS, so not sure what's required to get them into project form.
Are the packages already in a project in SSDT? If not,...
June 27, 2019 at 2:58 pm
Seems like it's still an issue, I just had to log back in, and I'd made posts this morning (on this device). Weird. :/
June 27, 2019 at 2:47 pm
Do you have them in a project? SQL Server 2012 introduced the project deployment method using the SSIS Catalog; that just a few steps to deploy the whole lot (though...
June 27, 2019 at 1:09 pm
Honestly, I would want this change to occur before it ever gets to your database; it shouldn't be part of the INSERT. Even if you're replacing the value with an...
June 27, 2019 at 11:16 am
Interesting, is it just me, or would anyone read that from the note on the latest version of What's new in SQL Server 2019 preview that although 2008(R2) won't...
June 26, 2019 at 6:43 pm
Not sure I understand what you're after here. For what you've provided what is the result set you're after?
June 26, 2019 at 4:08 pm
My Mom (who isn't a tech person) thought that Microsoft updates would come down to her laptop if it was plugged in, but the lid was closed. She thought...
June 26, 2019 at 10:54 am
Are the users using their own credentials to run the report, or is it being run by a service account? If the former, is this something you could achieve with...
June 26, 2019 at 8:12 am
I am embarrassed. Found out that some idiot user had indeed entered bad data.
This is why I tend to trust the data first, my preconceptions second, and the users...
June 26, 2019 at 7:53 am
Hmm....seems we (or at least I) don't have the ability to flag posts as spam anymore. Other posts on that thread can be reported. What's the deal here??? ...
June 25, 2019 at 3:26 pm
Viewing 15 posts - 871 through 885 (of 5,111 total)