Topics
Started by
Posts
Last post
DECLARE @MyDate datetime SET @MyDate = '2/28/2009' SELECT DATEADD(year,-1,@MyDate) Desired result …
10 replies
By: x
Hi, I'm trying to find a way to import data from this data xml feed to get daily exchange rates. I'…
1 replies
Hi.. I have created one trigger in table on insert but it is catching previous row not inserted row…
3 replies
Hi All, I have a Transactional table containing IDs that relate to each other. The table highlights…
17 replies
By: Bruceo
hello, I have two tables i.e sales_header and sales_item_details And there is another table sales_a…
4 replies
Hi, to assign grading system, i want to skip some rows and update based on that. For Example, 1st …
1 replies
I have this View and want to also see Clubs that do not have current memberships. I have the IS NUL…
93 replies
Hi Guys, Received a lot of help from SQL Guru WayneS on SQL listed below however since there are ne…
2 replies
From data below I need to return unique jobnbr and tasknbr where Item_type = task or Item_type…
12 replies
Hello I have the following: sp_MSforeachtable @command1="delete from ? where '?' like '%_st]'" Rath…
7 replies
IF EXISTS ( SELECT TOP 1 1 FROM sys.tables WHERE name = '#EmpHours' ) DROP …
7 replies
If object_id('tempdb ..#sem01') is not null drop table tempdb ..#sem01 create TABLE #sem01 (Studen…
2 replies
Hi, Sample data to play with, declare @Process table(ProcessId int identity(1,1) primary key,Proce…
12 replies
What is the best formula to do this in SQL? This is from Access SELECT Year([EndDate]) AS SeasonY…
3 replies
I need help to create a sequential aggregate of a column using sum in tsql. I want a column that wi…
5 replies
Viewing 15 topics - 1,036 through 1,050 (of 10,647 total)
You must be logged in to create new topics.