Viewing 15 posts - 1 through 15 (of 138 total)
You don't want to be using "IN (SELECT PO_Detail_Status FROM dbo.DelimitedSplitN4K(@status,','))". You want it to be SELECTing the column that comes out from DelimitedSplitN4K.
Could you run the below and tell...
September 22, 2020 at 12:08 am
I use (and am grateful for) the string splitting function made by Jeff Moden on our pre-SQL 2016 instances. I suggest taking a look at his article on this
September 21, 2020 at 8:24 pm
This is nearly there. To correct your procedure, you need to have a "SELECT <column name> FROM " in front of "dbo.fnSplitStringList(@Status)". The column name is what the column...
September 19, 2020 at 3:34 am
@ronaldkunenborg apologies for the delay in responding. Thanks for the suggestion to push SalesOrder down into SalesOrderLine. I'm planning on moving the SalesOrder details to a dimension from...
September 17, 2020 at 10:02 am
@dmbaker: Thanks for your reply - I'm sorry I hadn't replied earlier. I think you've directly hit on some of those misunderstandings, and I really appreciate you taking...
September 17, 2020 at 9:52 am
It sounds like you're on the right path - seeing this as a final option given that this behavior is severely impacting the business. I think it will work.
April 11, 2020 at 12:20 am
Yes, that's possible, but you do want to consider whether that URL needs to be stored/generated in SQL Server where it is consuming resources on the SQL server, or...
January 17, 2020 at 9:58 am
I can't see if you're using an AFTER INSERT or INSTEAD OF INSERT trigger. It sounds like you're having problems with an AFTER INSERT trigger, because you're describing that...
January 12, 2020 at 12:48 am
We use a date table, but not in a high-throughput environment. Here's my thoughts:
I recommend against #3 - requiring users calculate the date-related fields themselves (especially for the commonly used...
January 1, 2020 at 2:58 am
I recommend pasting the stored procedure text into SSMS, then running it (if appropriate), to verify you don't have invalid syntax.
If you're not able to, or the query is...
December 30, 2019 at 11:46 pm
If your table has a clustered index (one of these is created by default when a primary key is added to the table) on an auto-incrementing integer, then you...
December 29, 2019 at 11:15 pm
msdb holds Agent jobs. master holds logons, linked servers and system settings (and master database keys used to encrypt certificates), and model is the template database used when any...
December 26, 2019 at 8:14 pm
No, I wouldn't expect a junior SQL Developer to know Hadoop.
You mention you're a newbie in the field of SQL development. If you're expected to write T-SQL in your...
December 24, 2019 at 12:38 am
Replacing SELECT * with a list of the columns you want to return would usually improve performance (unless you listed every column), but in this case it has no effect....
October 22, 2019 at 6:23 am
You're correct, the report .rdl files are stored in the Content column of ReportServer.dbo.Catalog. None of our few SSRS deployments have .rdl files stored in folders on their drives, and...
October 8, 2019 at 12:29 pm