Topics
Started by
Posts
Last post
I am creating a single stored procedure to log errors from within the CATCH blocks in my code. I n…
2 replies
I have a table with a "from date", a "to date", and a total interest amount. I need to work out, on…
10 replies
I am using a database with a CI collation, but where some of the columns in some tables are set to …
2 replies
Hello everybody, I have to export the records of a table in a .txt file but in a strange way (in a …
1 replies
Hey Gang- I have an interesting challenge which I haven't fully been able to wrap my head around. I…
25 replies
I learned the other day to use sp_add_jobschedule to add a Schedule to an existing job. Is there an…
3 replies
Hi Can somebody share some experience about some general set statement in your project? e.g. SE…
1 replies
In the MSDB MS is storing the information about a SQL Job, and in the DBO.SysJobHistory it has a co…
10 replies
Hi, I'm trying to fix a stored procedure within our production db. We have a notes table where user…
5 replies
Need help with creating a unique index with clause (SQL Server 2005 SP2). Below is my requirement: …
16 replies
I'm having some trouble grasping the use of CASE statements (used to using If/Then). I would like t…
10 replies
Hello, how many types of joins and briefly explain them. Regards, sathish.
12 replies
In my stored procedure, I have a variable I have declared: @spot_exists int If I run the following …
5 replies
Declare @A AS NVARCHAR(16) SET @A='1' Select Case WHEN ISNUMERIC(@A)=1 THEN Cast(@A AS int) ELS…
4 replies
I have the following stored procedure. It works fine running it in SQL Server but when I run it in…
4 replies
Viewing 15 topics - 361 through 375 (of 12,234 total)
You must be logged in to create new topics.