Topics
Started by
Posts
Last post
I'm trying to roll multiple records into one replacing null value. IF (SELECT OBJECT_ID('tempdb..#T…
3 replies
Hello, Why would select count(*) from a table encounter a lock? The table in question had initial b…
8 replies
I'm doing development on large SCD2 tables (100M+ rows). When I've fixed bugs and it's time to re-…
9 replies
how can the meaning of this Where clause be explained in a human language? this query <does what…
13 replies
Hi all, I am once again facing an interesting issue with multi-threading in SQL Server 2016. But fi…
12 replies
I have date which is stored in Integer how do I get data older than 12 months select * from table1 …
5 replies
Hello, I'm working on migrating some data from an old system into a newer one. Their table …
3 replies
Hello, I'm performing a backup/restore operation from a SQL Server 2012 database server to a SQL Se…
7 replies
Hello, Our reporting database truncates and loads latest data during each import and generates Uniq…
4 replies
Hi I would like to extract from a full string the 'XX....' string. This specific string inst in the…
6 replies
In the below query, the data returned in the query is in xml format. I'm receiving an issue with d…
1 replies
We have five different report servers, with 13 or so different databases, all with the same structu…
2 replies
I don't have permissions to right click\design views or to script the views. Is there another way …
3 replies
I have a table SASSTATS_ALL that holds the column name and Table name. I used another function to …
5 replies
I am writing some fairly complicated dynamic SQL for a stored procedure that needs to be multi-purp…
26 replies
Viewing 15 topics - 1,021 through 1,035 (of 3,091 total)
You must be logged in to create new topics.