Viewing 15 posts - 871 through 885 (of 5,109 total)
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?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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. :/
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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??? ...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 25, 2019 at 3:26 pm
Guessing this was resolved, as you can find the topic here.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 25, 2019 at 2:22 pm
Viewing 15 posts - 871 through 885 (of 5,109 total)