Topics
Started by
Posts
Last post
Hi all Short version: USE StagingDBtemp -- new empty database with same design as StagingDB created…
6 replies
I work on sql server I need to rewrite statement after where statement so how to rewrite I don't un…
3 replies
I'm getting an error in the following query, can anyone help with? Of course ConcatCount is not all…
4 replies
I Googled around for a while for a solution on this and not finding one I decided to write/share my…
12 replies
Hello, I have a requirement to send an Alert based on Silo Level data , when it hits <= 30% Th…
6 replies
Morning All, I’m stumped on a sqlquery and thought I might ask for some help. first time I'm tryi…
5 replies
Consider the following: DECLARE @docHandle int; DECLARE @xmlDocument xml set @xmldocument = N' &l…
2 replies
Hi, I need to get the XSD for an XML field on a table. I know I can take the XML and generate the X…
2 replies
I'm trying to put this basic code below into a parameterized View and need to simplify where possib…
18 replies
hi all, I need some help as I have a table contains issue & reply dates and need to make query …
2 replies
I have the following values in a table . This table is stores CDC data ( as it was captured) from t…
2 replies
Hi, I work in a hospital and look after a db containing the surgical procedures performed on our pa…
12 replies
I'm trying to create a query that pivots on 2 fields(entity,channel) and produce a daily sum of cha…
11 replies
Is there a way to take these two records and update the NULL values in one to match the filled in v…
11 replies
I'm doing an update using a self-join, and just want to confirm something. If the query updates a…
5 replies
Viewing 15 topics - 106 through 120 (of 4,982 total)
You must be logged in to create new topics.