Topics
Started by
Posts
Last post
I have a table with some examples below. I need to identify records where: 1. the person has 3 or m…
6 replies
this is what i have for a query but i would like to take the year off. is there a way i can just ha…
3 replies
I have the following Games table: CREATE TABLE [dbo].[Games]( [ID] [int] IDENTITY(1,1) NOT NULL, …
17 replies
Hi Team, I have a description field in a table which also stores unit of measure in the same column…
9 replies
Hello, I have a table with EmployeeID, StartDate, and EndDate with a PK of EmployeeID, StartDate. H…
7 replies
I'm dealing with filtering system which should control whether input string contains bad words or n…
10 replies
Hi, i tried to use xp_cmdshell in order to execute a vbscript from a trigger and it works, but i no…
6 replies
Hi , I have created a Dynamic Merge statement SCD2 Store procedure , which insert the records if no…
4 replies
So, one thing I've been having issues with is differentiating between IN and EXISTS, as essentially…
3 replies
Hi I am having the following errors with the script below Msg 102, Level 15, State 1, Line 44 Inco…
6 replies
Issue #1 I have a report that takes 8 character parameter, A error message needs to popped out if u…
1 replies
Hi, How to write a Dynamic Pivot Statement to Calculate and Organize Columns like: CREATE TABLE #my…
5 replies
I have the following query that displays 2 values. I want to add a column with the percentage ([Pr…
1 replies
I swear there was a topic on this in the last few months, but I can't seem to find it searching the…
3 replies
Hi all, I have a script which contains lots of union all statements like this: SELECT 'DAR-901 MDE…
8 replies
Viewing 15 topics - 3,346 through 3,360 (of 4,984 total)
You must be logged in to create new topics.