Topics
Started by
Posts
Last post
Hello, I have a query that aggregates a value based on a date range and excludes business hours. I …
13 replies
I have a T-SQL problem I need to sort and need help as my grey matter is hurting! CREATE TABLE #Cus…
3 replies
I have this query that gives me Select WeekRange as WeekRange, [Open] as 'Open', [Resolved] as '…
1 replies
Hi, I have several rule on my item name to compute its gender. I know this structure might need to …
4 replies
Hi All. I am trying to concatenate multiple field values from a table in one string. Example: IF S…
30 replies
I can't understand what is happening inside the cursor when you set a variable to null: SET @str…
8 replies
hi i'm trying to delete products in a media event details table where no base forecast exists for t…
15 replies
Hi im having a problem with date range searchin in SQL... the database consist of 2012 -2013 data. …
3 replies
Hello and happy new year! I wrote a stored proc that basically aggregates some data based on how ma…
7 replies
I've got a development scenario where stored procedures (sprocs) will output diagnostic/debug messa…
3 replies
Hi, I am in process to compute query result set size to compute its impact on network. I am using c…
1 replies
Here is what I have, DECLARE @document varchar(200); DECLARE @document1 varchar(200); SELECT @docum…
3 replies
Is it possible to write the Sub Routine inside the Stored Procedure like below ? The reason I would…
6 replies
Hi, I want SUM of count of the number of records available in database for first WHEN in below quer…
9 replies
Hi All, I have an requirement that, i have to Encrypt Salary's Information in my database. Basicall…
1 replies
Viewing 15 topics - 451 through 465 (of 12,234 total)
You must be logged in to create new topics.