Topics
Started by
Posts
Last post
Stupid Troublesome Error Code: The INSERT statement conflicted with the FOREIGN KEY SAME TABLE cons…
6 replies
Hi All, Need help on some recursive Data. I would need to get 4 records out of below available If I…
7 replies
This is probably very simple but I can't get it to work. If trying to write this Case Oppo_stage Wh…
9 replies
Hi guru's Thanks for your support this is my following situation DECLARE @A as TABLE(Eid VARCH…
3 replies
Hello All, I was prescreened for a Senior SQL Program Analyst position and one of the questions ask…
11 replies
Just curious - what are the various options available for testing t-sql code in stored procedures? …
1 replies
Hi All, select Case when MONTH(GETDATE())=1 then 12 when LEN(MONTH(GETDATE()))=2 then MONTH(GETDA…
5 replies
DECLARE @TblData TABLE( OrganizationName VARCHAR(100), DeptName VARCHAR(50), Total int) INSERT INTO…
3 replies
Hi, We have fiscal quarters like FY13-Q1,FY13-Q2.. Need to display last 6 quarters (FY12-Q1 to FY13…
4 replies
I have two tables. Table #1 CREATE TABLE [XXX].[SLHIH]( [WorkDate] [date] NOT NULL, [BusinessUnit]…
11 replies
I receive data from an external data provider which comes in as a single large table. The data rep…
19 replies
I have a value that is '0111~Group Name' in a column called GROUP_NUM in a table called TEMP_TABLE …
9 replies
Hi, I am familiar with SQL and have created queries. With TSQL the problem I'm having is I'm not su…
2 replies
Hi,I required help in creating this type query Create table #temp (ID int,VoucherNo varchar(10), St…
3 replies
When I executet his query it takes a lot of time...Can anyone plz help in this? SELECT id, english_…
7 replies
Viewing 15 topics - 3,706 through 3,720 (of 10,647 total)
You must be logged in to create new topics.