Topics
Started by
Posts
Last post
College of mine tells me that IF statement in stored procedure is not a good idea becuase: 1) it ei…
3 replies
I have a code using except function can any one rewrite the code using sub queries? I am using 2 da…
4 replies
Hi, One of my developers has sent me some code for optimization and she has managed to stump me wit…
3 replies
I need help bad. I have read a ton or articles and for whatever reason I can not export the results…
2 replies
Hi i got three tables table1, table2 and table3 like TABLE1 create table1 ( source varchar(500) ) …
2 replies
DECLARE @result int EXEC @result = master..xp_cmdshell 'C:\AYSS\encrypt_by_GPG.bat' IF (@result = 0…
3 replies
Hi folks A simple question, but after several hours of searching I don't have a workable solution -…
3 replies
I recieve a strange error from sql server , Msg 0, Level 11, State 0, Line 0 A severe error occurre…
2 replies
My database is on a hosted server in a different time zone. All of my GETDATE() updates are an hour…
2 replies
Hello the below query will give is giving me users who are blocked in the past 2 days, I want to ch…
5 replies
Table to populate: Summary Table: MinAge,MaxAge,CountPersons,AmountToPay 0,10,0,0 11,20,0,0 21,30,0…
1 replies
I've tried searching this site, because I know people have made reference to this. The closest I co…
2 replies
So here is the situation. We have 2 similar applications. One is using an Informix database, the ot…
5 replies
i got a table with multiple rows Let us consider courses tabel courses Table: Course count …
1 replies
I'm debuggin a prod issue. There is a job that runs the below sql. I don't know who wrote it and th…
9 replies
Viewing 15 topics - 9,886 through 9,900 (of 10,647 total)
You must be logged in to create new topics.