Topics
Started by
Posts
Last post
The Plan: To compare 2 tables that have the same structure and when the table which is updated dail…
10 replies
Good morning, The following block of code assigns a sequential GL_Control number to a batch of post…
12 replies
Hello friends , i found a difference between two script dts but i dont know why???, mmm i th…
2 replies
I have a proc (RptGPHistUpdt) that fills a reporting history table (RptGPHJVHist) for each wee…
2 replies
Hi, This statement fragment works in query analyzer: Age=DateDiff(d,CS.AdmSrvDate,GetDate()) but wh…
7 replies
Hiya, I have a table open in EM. Is there a way to enter a current timestamp into a datetime/smalld…
8 replies
delete from POL_COV_RATE_DTL_V C1 where C1.ROW_ACTIVE_STS_D = 9999999 and C1.UNITCOVERAGE_ID in…
4 replies
How would I setup a T-SQL statement that would automatically delete data that is 18 months (or olde…
1 replies
Does anyone know, given that using the 'updatetext' function requires an initial query to obtain th…
3 replies
Friends is possible to do an 'on error goto' in TSQL? well occurs that one sp of my company …
3 replies
I need to do a DTS for traspassing datas from a txt to a table, but in the txt exists a regist…
6 replies
I've got a table, tbMAIN which contains a VARCHAR(32) field 'Ticker' as well as an INT field InstTy…
4 replies
I have 2 tables with data as. Table A FName LName Value John &nb…
5 replies
Hello, wondering if any have encountered this problem: I am looping through about 50,000 rec…
17 replies
if i run the following query declare @sql varchar(7000) set @sql = 'select * into #mytemp …
2 replies
Viewing 15 topics - 10,696 through 10,710 (of 17,082 total)
You must be logged in to create new topics.