Viewing 15 posts - 1,186 through 1,200 (of 10,144 total)
TheSQLGuru (9/12/2016)
ChrisM@Work (9/12/2016)
Phil Parkin (9/12/2016)
Don't explicitly drop the #temp table
Hi Chris. Can you explain a little how not dropping the temp table affects things, please?
From memory Phil, if you explicitly...
September 15, 2016 at 2:02 am
vs.satheesh (9/14/2016)
Thank you for your reply. But my client using sqlserver2005.This Query not working in sqlserver2005.
Please post the helpful error message.
September 15, 2016 at 1:45 am
No, and we're using exactly the same version as you. We're not using SQL Prompt.
September 14, 2016 at 9:41 am
Jason A. Long (9/14/2016)
Just an FYI... Chris and I are using the same split function. We...
September 14, 2016 at 9:01 am
SQL Galaxy (9/14/2016)
Yes. it is there..I checked - select * from sys.sysservers,
servername and datasource as below name
targetserver,96361
There's a linked server with a nondefault port on the instance I'm...
September 14, 2016 at 7:54 am
mytesting9 (9/14/2016)
QW1 ABC
SA2 CRF...
September 14, 2016 at 7:24 am
Phil Parkin (9/14/2016)
ChrisM@Work (9/14/2016)
--
That's why I asked the feller the question
--
I think you meant 'fella', rather than 'lumberjack'. Then again ...
For the OP, there's this: "non-standard spelling of fellow, used...
September 14, 2016 at 6:56 am
Using the house string-splitter[/url]:
SELECT
t.[KPI ID],
t.[KPI Name],
KPIFormula = ISNULL(x.KPIFormula,'No Formula')
FROM #KPI t
CROSS APPLY (
SELECT KPIFormula = STUFF((
SELECT '+['+[KPI ID]+']'
FROM dbo.il_SplitDelimitedStringArray(KPIFormula, '+') d
LEFT JOIN #KPI ti ON '['+ti.[KPI Name]+']'...
September 14, 2016 at 6:41 am
jasona.work (9/14/2016)
GilaMonster (9/14/2016)
ChrisM@Work (9/14/2016)
Eirikur Eiriksson (9/14/2016)
Kingston Dhasian (9/14/2016)
How would somebody respond to this? The last statement of the OP is a cruel joke.http://www.sqlservercentral.com/Forums/Topic1817507-3739-1.aspx
Makes you wonder what the purpose is and...
September 14, 2016 at 6:19 am
Bharat21 (9/14/2016)
September 14, 2016 at 4:51 am
Eirikur Eiriksson (9/14/2016)
Kingston Dhasian (9/14/2016)
How would somebody respond to this? The last statement of the OP is a cruel joke.http://www.sqlservercentral.com/Forums/Topic1817507-3739-1.aspx
Makes you wonder what the purpose is and English certainly not...
September 14, 2016 at 4:18 am
ashishkumarrai (9/14/2016)
J Livingston SQL (9/13/2016)
ashishkumarrai (9/13/2016)
September 14, 2016 at 2:34 am
Eirikur Eiriksson (9/14/2016)
😎
BTW DON'T USE the FORMAT function!
USE TEEST;
GO
SET NOCOUNT ON;
DECLARE @LINE_TEMPLATE VARCHAR(50) = '000000000 ...
September 14, 2016 at 1:58 am
WITH SampleData AS (SELECT * FROM (VALUES
('30', CAST('Mike' AS VARCHAR(30)),1600, 300),
('30', 'GIRISH',1250, 500),
('30', 'MARUTI',1250, 1400),
('30', 'MANOJ',1500, 0)
) d (Department, [Name], Salary, Commission))
SELECT
OutputString = RIGHT('000000000'+Department,10)
+ LEFT([Name]+SPACE(20),20)
+...
September 14, 2016 at 1:56 am
Matt Miller (#4) (9/13/2016)
ChrisM@Work (9/13/2016)
Jeff Moden (9/13/2016)
ChrisM@Work (9/13/2016)
Cache priming can make a very significant difference to batch delete times.
Curious... isn't that just moving the problem to something else? ...
September 13, 2016 at 10:15 am
Viewing 15 posts - 1,186 through 1,200 (of 10,144 total)