Topics
Started by
Posts
Last post
Hello, I have been stuck here now: I have a table with score info for each group, and the table als…
3 replies
Hi, I need to return the max value from a fieldwhich contains a three part numeric, stored as a va…
11 replies
Below are my table Structure, declare @tblCompanyProess table (IdProcess int identity(1,1), UserId…
21 replies
I have a constraint on a 3rd party app that I can't change the app but can add a constraint at the …
3 replies
select datediff(wk, '2015-01-11', '2015-01-19') returns 1 (shouldn't it return 2?) select datediff(…
5 replies
Hello, I have a script to be used to backup a specific table in a weekly basis, here is the approac…
17 replies
A table called "Employees" can have several triggers, assume there are 10 triggers created of all v…
4 replies
I have a 3rd party app and db where I can not add constraints or change the data type. They have a…
7 replies
Found out I could not do a rule so i need a constraint on a varchar(5) field that can contain null …
1 replies
Hello I'm using sp_send_cdosysmail in HTML format while hosting the image(logo) as a regular web i…
2 replies
Hi, Below data is my output of one of the query, With Record (Months,RScore,RAmount,Rvisit,TotalAm…
13 replies
Consider a situation where a stored procedure taking a varbinary(max) (BLOB) input parameter then c…
8 replies
I have table called Tracking_changes which contain 5 columns and 5th column as getdate I want to ge…
6 replies
Hello, I have a query to get data group by High, Medium and Low so only three rows will be returned…
2 replies
Along with the data that I am pulling back from query, I also need to provide an ImportID column wi…
7 replies
Viewing 15 topics - 1,471 through 1,485 (of 10,647 total)
You must be logged in to create new topics.