Topics
Started by
Posts
Last post
I have 2 tables: users, traffic. The first table consists of the users information (id, name, user_…
1 replies
Hi friends, I'm trying to create a trigger for audit, I would like to get some help here with after…
4 replies
I'm sorry if this isn't the place to ask about SSIS, but here it is. I have created a project ran …
2 replies
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
By: ratbak
(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
By: cphite
CASE WHEN PM_LETTING_DATA.CONST_EST_AMT IS NOT NULL THEN PM_LETTING_DATA.CONST_EST_AMT ELSE '0.00' …
3 replies
By: Ed B
Hi All, I have this sample xml data with subgroups. I have identified the fields in the source data…
4 replies
By: kaj
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
By: JeremyU
Viewing 15 topics - 676 through 690 (of 1,793 total)
You must be logged in to create new topics.