Topics
Started by
Posts
Last post
HI all I have been asked to generate reports from my c# package I have created every Monday at 0700…
49 replies
Hi, I have a SQL proc with a search-parameter (given as coma separated values) which should return…
12 replies
I have declare Start Date in below format. Declare @StartDate date = '2013-01-01' I want get outpu…
4 replies
Is the same space used by Clustered index and the column on which the primary key is declared?
2 replies
Table1: Reportid | IdetityID(Pimary key) -------- | ---…
6 replies
If I have a street address that I would like to split street from Apt number, how could I do that? …
6 replies
How To Validate a year, month,and date and totaldate?Year should be in yyyy format,month should be …
11 replies
I have written an IF ELSE statement into a sproc but I'd like to display the results (as in counts)…
6 replies
How to Retrieve A Field That is unique in two tables?
2 replies
Hello! I am new to TSQL and require some help with a problem I'm having. I have a stored procedure…
6 replies
SELECT CASE WHEN substring(column_name, 1, 2) = '44' THEN column_name ELSE '44' + column_name END '…
2 replies
DECLARE @X XML = <Movies> <Movie Name = "Titanic"> …
3 replies
I was joining nearly 5 inner joins and 2 left outer join Final with group by Here i am facing perfo…
3 replies
Hi, When I add the below line of code to my stored procedure, the performance becoems very poor. I…
3 replies
In the statement below, there is a problem where some records are occasionally duplicated. I have …
1 replies
Viewing 15 topics - 3,331 through 3,345 (of 10,636 total)
You must be logged in to create new topics.