Topics
Started by
Posts
Last post
I have two tables, one Master, one Detail. I'm trying to build a query to get the top 2 products by…
2 replies
Morning all Good someone offer the best way to do this. I want to add 2 values from 1 table. Exampl…
4 replies
EDIT: About four posts down is an expanded test script that if you get the chance to run for timing…
15 replies
I have a table w/a varchar(10) column (MoYear) which has the month and year with '/' between (i.e. …
8 replies
Hi, I have an existing piece of code that navigates through a hierarchy and was trying to figure ou…
2 replies
I have a data set that has ID and Total fields. Now I need a result set that has a third column, "A…
5 replies
Hai Friends, Im creating one table for web application these is my table structure. after wrote…
9 replies
Hi Everyone, Can anyone of you please help me to get the T-SQL to extract a string between two spec…
3 replies
I have data in a table like this: Parent Child 300001 110081 300001 102157 300001 …
2 replies
Hi All, Sorry if this has been asked somewhere all ready but I've struggled to find the answer! I…
2 replies
hi, I have created procedure like . USE [master] GO /****** Object: StoredProcedure [dbo]. Scri…
6 replies
My Transaction log is about 3GB and I can't shrink it. It is using a FULL backup and I try over and…
10 replies
/* I need to filter for duplicate students: --------------------------------------- For same studen…
23 replies
I think I'm about to fill a gap in my knowledge base, because I've been banging my head against thi…
8 replies
hi, i have below code declare @V_AreaId int = 1 declare @V_Area nvarchar(30)='xxx' declare @V_Pin…
3 replies
Viewing 15 topics - 3,766 through 3,780 (of 10,647 total)
You must be logged in to create new topics.