Viewing 15 posts - 16 through 30 (of 260 total)
i type wrong id
Yes, 'BL.2112.00627' isn't the same as 'BL.2111.00627', so not surprising that you may get different results from the two queries. 🙂
April 19, 2023 at 7:16 pm
As the OP want an opinion about the two code options presented, i.e.
Option 1:
DECLARE @strcol1 varchar(max), @intco11 int
SELECT @strcol1 += ','+CAST(col1 AS VARCHAR(20)), @intco11=col1
FROM (
...
April 11, 2023 at 6:58 pm
Or you could dispense with some paranteses, like this:
IF EXISTS (
SELECT DISTINCT UPC, U_PUBLISHER_TYPE
FROM [snapshot]
LEFT OUTER JOIN [item]
ON [UPC]=item.[ITEM]
WHERE item.U_PUBLISHER_TYPE IN ('PRPG', 'RMSP', 'RDSP')
EXCEPT
SELECT DISTINCT...
February 16, 2023 at 7:54 pm
Unless the "with the matching dates" is to be interpreted as a date range selection, in which case Jeff Moden's integer math would be needed to ensure that the 24...
February 15, 2023 at 5:04 pm
And now we're just waiting for Google's Bard chatbot to go to GA. Time will tell who is the more truthful chatterbox.
But Bard will probably not do any better, since...
February 7, 2023 at 7:40 pm
It apparently cannot make the distinction between "temp tables" and "temporary tables". It's seriously incorrect for what most of us refer to as "temp tables" and...
February 7, 2023 at 6:50 pm
It apparently cannot make the distinction between "temp tables" and "temporary tables". It's seriously incorrect for what most of us refer to as "temp tables" and seriously correct for...
February 7, 2023 at 6:01 pm
Sorry, but that's not valid JSON.
Generally, what most people do, is to flatten the structured JSON into one table, which can later be queried and grouped.
Alternatively you can also use...
February 7, 2023 at 5:34 pm
Dear All,
My one condition is working like if data exist than it should fail only one condition is pending that is "if data exists without qty, than qty should...
February 1, 2023 at 6:57 pm
My guess is that in reality it's the fact that you have a window function that sums transaction_amount that the engine is barking about. Mixing a group by and a...
February 1, 2023 at 4:26 pm
What's the relationship between the two tables? Are they to be joined, and if yes, on which columns?
January 31, 2023 at 8:42 pm
@ Michael L John:
Agreed, I like a typed table valued parameter for passing a set of rows to a stored procedure or between a stored procedure and a table function,...
January 31, 2023 at 7:58 pm
@Ant-Green: There seems to be a mis-match between the row values and the column definitions of the table variable. You have two integers that doesn't match up with the row...
January 31, 2023 at 7:21 pm
I don't think you can use VALUES quite like that.
This should work:
WITH ctevalues (recp_name, ing_name, qty) AS (
SELECT v.*
FROM...
January 31, 2023 at 7:13 pm
Ant-Green is correct, something is not right.
Are you connected to the correct server? Have you selected the correct database, before firing off the statement? I see no USE statement at...
January 31, 2023 at 6:11 pm
Viewing 15 posts - 16 through 30 (of 260 total)