Topics
Started by
Posts
Last post
hi there, am new to SQL and now am trying to do row split. e.g currently i have two group of record…
1 replies
HI, I have a sql server stored procedure and it uses hard coded value (e.g sql server service accou…
6 replies
I have an SSIS project that I am trying to deploy. When I run in debug mode it executes successfull…
9 replies
I have a stored procedure (actually it's a developer's code) - my dev is complaining that while he …
2 replies
Hi Friends, I was wondering what would be the best way to insert O's into the field number of items…
3 replies
I am trying to use CHECKSUM() to streamline a WHERE clause that detects when a row in one table is …
6 replies
Hello I've been playing around with some of the out-of-the-box Query store reports I have no…
1 replies
I have a table like this: Year month col_abc1 col_abc2 col_abc3 col_abc4 col_processing 2019 1 a1 a…
6 replies
I have a query that creates an xml file but I'm getting errors because the XML is too large. I've a…
2 replies
What is simplest way to go about gathering business requirements and determining database schemas?
3 replies
Hello Everyone Thought I knew how Window functions worked in SQL Server but that was before I ran …
3 replies
Hello I am having an issue with the query stats dmv If I run a statement or execute an SP I …
6 replies
Hi Friends, I know that we have a left and right outer join that retains the rows of the table base…
4 replies
i have a variable called date @Date DATETIME = NULL, i want to capture this variable into error log…
2 replies
I could use some help with the following COUNT issue. Select distinct Model_id, COUNT(CASE WHEN Doo…
3 replies
Viewing 15 topics - 1,216 through 1,230 (of 3,091 total)
You must be logged in to create new topics.