Topics
Started by
Posts
Last post
A brief description: We have a device/software version tracking table that contains the history of …
4 replies
I have a table called order and i have a field called orderdate as datetime i want to check if the …
4 replies
My tables and rows as follow, declare @t1 table ( idx smallint, desn varchar(50) ) insert into @t1 …
3 replies
I have a read-only database that is a nightly snapshot of our core system DB2 database. It is crea…
6 replies
declare @temp table ( id int , phn int) insert into @temp select 1 , 16454 UNION SELECT 2 , 5485 UN…
3 replies
I am trying to figure out how to split one single field that has data with commas into multiple fie…
16 replies
CREATE TABLE Temp (ID1 INT,ID2 INT,ID3 INT) INSERT INTO Temp (id1,id2,id3) select 1,1,61 union all …
5 replies
I want to get a distinct count of my LID as well as distinguish between Shift Groups using the LTim…
3 replies
I inherited some ugly nested case statements. I would like to see if there are any alternatives so …
1 replies
My tables as follow, CREATE TABLE [dbo].[tPickPointH]( [idx] [smallint] IDENTITY(1,1) NOT NULL, […
4 replies
hello All, I will get straight to business. Any suggestions are higly appreciated and many thanks f…
5 replies
I have the query below. Everything works right except for the CASE section at the end. I think I …
10 replies
Copied from another thread I hijacked: CREATE FUNCTION [dbo].[ConvertUnixDate] ( @TimeValue …
1 replies
Hi, Could anyone please help me in writing a query to find the weighted Median for the following da…
12 replies
Hi, I've been scratching my head with this one for a while. I hope someone can point me in the rig…
5 replies
Viewing 15 topics - 4,156 through 4,170 (of 12,230 total)
You must be logged in to create new topics.