Topics
Started by
Posts
Last post
Hi i wrote an storeprocedure alter PROCEDURE [dbo].[SearchEmployee] @VarEmp_Id int, @VarEmp_Name nv…
1 replies
Dear Team, Kindly look into my problem DECLARE @Table TABLE ( id int, ClientIdINT, bnmk_dt DAT…
21 replies
Hi all, I inherited a lot of code that was written back in the early 2000's and recently it's start…
4 replies
I usually write the following, but I am now inputting data from 2 .net scripts, I use the identity …
12 replies
Hi - I'm using sp_send_dbmail in a stored proc. When executing my stored proc as sa it works fine, …
6 replies
I am using BCP to perform a bulk insert into a table. Below is an example line item from the data …
3 replies
Hi all, I have a killer query which is cracking me up. Imagine I have the simplified data set below…
3 replies
Hello expert, Using this sql statement datepart (week, '2005-01-01') returns 1 for week 1, I would …
4 replies
Hello all! Given the following situation: A certain way of handling an employee's overtime is depen…
9 replies
:-P1.SP_ Template @Code char(30), @Path varchar (50), @PathReadOnlyInd int The SP must update table…
5 replies
Hi i have requirement where i need to check the a business DB when the parameter is getdate() ELSE…
4 replies
I am trying to write a script where if fragmentation is >= 30, then if the large object (LOB) da…
1 replies
I have the following code: It returns a divide by zero error when oe_line.unit_price is 0. Apparent…
11 replies
I had an odd request from a user.. They are having an issue with the app where it is inserting lowe…
1 replies
All, one of my co worker sent a query this morning and told that it is running for 12 seconds. He a…
1 replies
Viewing 15 topics - 3,736 through 3,750 (of 12,234 total)
You must be logged in to create new topics.