Topics
Started by
Posts
Last post
Multiple single quotes in my column's data value is causing my SSIS pkg load to fail. I extract fro…
2 replies
WITH MAXPRedID as ( SELECT MAX(ID) + 1 AS MaxID, SystemID FROM dbo.TableA GROUP BY SystemID) SE…
4 replies
I need a T-SQL script to find, for a given view across all databases (they all have this one partic…
13 replies
Hi In below code it is giving error - column,status is invalid in the Select Statement because it i…
1 replies
I struggle with XQuery and Xpath, I am sure the following is possible but I can't work out how to d…
2 replies
Hi, I have a below query. Instead of average I need to calculate median for the below query. Could …
1 replies
(If {@route}='' then if ({@USRoute}='') then '' else ('('+{@USRoute} + '), ') else if ({@USRoute}='…
3 replies
Okay so this might be a n00b question but it's something I've been wondering about. Say I have the…
2 replies
CASE WHEN PM_LETTING_DATA.CONST_EST_AMT IS NOT NULL THEN PM_LETTING_DATA.CONST_EST_AMT ELSE '0.00' …
3 replies
Hi All, I have this sample xml data with subgroups. I have identified the fields in the source data…
4 replies
I am trying to insert same set of records with student id 1234 (All 4 records with student id 1234 …
8 replies
I have such a situation. I am trying to get MIN and MAX values of one field for all rows. MIN (WEEK…
3 replies
Hello everyone In my code, I often use nested stored procedures. The processing of my stored proced…
10 replies
I import a table from a comma delimited file that has a separate date column and a separate time co…
6 replies
Hello everyone First, I want you all to know that I always search for an answer before posting here…
4 replies
Viewing 15 topics - 691 through 705 (of 1,805 total)
You must be logged in to create new topics.