Topics
Started by
Posts
Last post
Hi Friends, I'm new to TSQL and in my code I'm using - datediff(day,[WorkForce_JobPosting].[Job Pos…
3 replies
hi all, please find the following code DECLARE @intid as varchar(100) ='''BSEC0002''' + ',' + '''B…
3 replies
I have a Menu table with a structure like this: MenuID, MenuDesc, ParentMenuID, Sequence The Menu i…
11 replies
HI Guys, I came to a situation where I have to load XML file in SQL server tables. I have worked in…
1 replies
This post has the code and an Excel Workbook with results and expected results (Red text) My query …
4 replies
I have the following table in SQL Server 2008 DECLARE @UnitConvert table ( ID int identity(1,1),…
8 replies
So I have the following statement: SELECT ca.Caseid,[weeknum],[monthName], Response1_Num , Response…
21 replies
Hi, Thanks for your help in advance, working with XML nodes for the first time and finding it frus…
2 replies
I have a timesheet master table and a related timesheet detail table. Each detail row could trigger…
1 replies
Hi all, Below are two scenarios, however, what I am trying to accomplish is to catch deadlock error…
13 replies
The below query I have been piecing together is really slow. I was wondering if any of you might be…
4 replies
Here is a the table structure: MemberNbr Varchar(11) MemberCardNumber Varchar(10) EffectiveDate Int…
3 replies
Hi there, I've a ConsumerActivity table that records all the activities. Now, I need to find out th…
8 replies
I have a TimesheetMaster table which requires 1 or more "approvals". I've created an eventlog table…
4 replies
Hi All, can any one help on below query declare @tbl table (TBLID int identity(1,1),ID int,patient…
1 replies
Viewing 15 topics - 4,081 through 4,095 (of 10,636 total)
You must be logged in to create new topics.