Topics
Started by
Posts
Last post
Hello, I think I need a recursive cte query but unsure of the logic. I have data for 3 Divisions fo…
5 replies
Is the below with nested multi-line comments valid T-SQL code? I thought no because it has nested M…
4 replies
By: pandrhola
We have a few stored procs where we need to a dos command "net use" EXEC master..xp_cmdshell 'NET U…
3 replies
Hi Guys I have a store proc that delete a row from a and I would like to get the result of the del…
4 replies
Hi, we are working on low latency OLTP system. About 100000 rows per second gets inserted into one …
3 replies
We run a lot of SQL Server Jobs, but as they become not needed, we do not delete, but simply disabl…
4 replies
I will have to test this next week, but will not have a chance before Friday. My question is, if I …
10 replies
Hi, I have a requirement to fetch the year from an imported .csv file that can hold any kind of da…
4 replies
In Azure SQL DB, i want to merge records from the staging table to the production table. In the pro…
2 replies
Hi, We are getting issue of Insert bulk failed due to schema change of target table. We had created…
2 replies
By: saum70
I have a record, in those the three columns where firstname / last name and full name is empty. ID …
2 replies
Hi All, I have 5 country grouping tables with PK & FK foriegn key relationships that store mast…
8 replies
Why would using variables in place of hard coded numbers impact a query's performance? The below c…
6 replies
I'm trying to dynamically create a temp table, basing the column names on another table. It appear…
11 replies
Hello, I would like to build a table capturing data starting from 1st day of current year till next…
11 replies
Viewing 15 topics - 1 through 15 (of 3,091 total)
You must be logged in to create new topics.