Viewing 15 posts - 1 through 15 (of 152 total)
Ed Wagner (12/1/2015)
Good question to make me stop and think. Thanks, Hugo.
December 1, 2015 at 6:37 am
Stewart "Arturius" Campbell (4/17/2015)
Good question, thanks
April 17, 2015 at 5:39 am
RK Mandava (3/20/2015)
Ed Wagner (3/20/2015)
A simple one to end the week. Thanks.+1
March 22, 2015 at 11:52 pm
Thanks,
I am gng to install SQL 2005, But already I installed SQL 2012 and Visual studio 2010,
Should I Uninstall Visual Studio 2010 ?
March 11, 2015 at 1:52 am
Hi
use this below code to get indivual value from given string
---------
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create FUNCTION [dbo].[CommaSeperateValuesToTable] ( @CommaseperateString VARCHAR(Max), @Delimiter nvarchar(1))
RETURNS @Result TABLE ( [Value] VARCHAR(50) )
AS
BEGIN
...
March 11, 2015 at 1:48 am
Can u elaborate your requirement , It seems your query not sync with requirement , What bases you want unique department to each user,
Based on ur query , always returns...
March 11, 2015 at 1:29 am
twin.devil (2/18/2015)
good question. reminded me some old thoughts 🙂
February 18, 2015 at 1:07 am
I am creating history table dynamically, by using INTO clause. After that I would like to purging data from Main table to History table.
Requirement: Create history table , and purge...
January 4, 2015 at 11:02 pm
Koen Verbeeck (11/4/2014)
You can also use the debugger functionality of SSMS to step through the stored procedure to see on which line it exactly fails.
I did that one also, found...
November 4, 2014 at 3:02 am
Based on conditions i am concatenating string to that variable
i.e.
SET @QRY = 'select EMP_ID AS SITE_ID, EMP_FIRST_NAME AS SITE_NAME from EMPLOYEE where EMP_ID in ( '+@agentsSelectMany+')'
and also not...
November 4, 2014 at 2:41 am
Viewing 15 posts - 1 through 15 (of 152 total)