Topics
Started by
Posts
Last post
Hi, I am using the query below and am getting back four 'Gary' records. Which I understand why that…
2 replies
I've a simple TSQL query as follows SELECT COUNT (PaxNum) as TotalPassengersCount FROM dbo.FlightD…
7 replies
Following query taking lots of time to execute. I am executing this in SSRS. I tried my level best …
5 replies
Needed a way to find datediff which renders result as follows: -- HH:MI:SS:MMM(24H) format . ie. …
11 replies
I need your help. I have instruction to update a table. The instruction is simple "IsValidSap (shou…
7 replies
I have a situation where at the end of a remarks string, there is anywhere from 1 -9 "char(9)" at t…
7 replies
drop table #TypeCode create table #TypeCode(TypeCodeId int identity(1,1), TypeCode bigint, Name var…
3 replies
Hi In one of my query I need data to be sorted starting with current month. Here is sample script: …
10 replies
I am new to sql and would like your help. I have a table that lists an payroll reference number for…
2 replies
Thanks if you can help. I have a data set that contains a current record of available units for tha…
4 replies
I am trying to add this query in data set. Basically we are using cascading parameters SELECT DIST…
1 replies
Hi All, I am havinfg a column in a table which store a date. say for eg birthDate. I want to displa…
5 replies
Hello. I have a portion of a table that looks like what I've listed below. This is just a small s…
5 replies
Hi Friends, I want to implement the SCD with row level log using CheckSum option My Source table : …
7 replies
Hi - What is a best way to set a field value to today date and time would be a always set to 4:00:0…
11 replies
Viewing 15 topics - 2,896 through 2,910 (of 10,635 total)
You must be logged in to create new topics.