Viewing 15 posts - 6,331 through 6,345 (of 10,144 total)
riya_dave (5/9/2012)
i remove cursor with while ,not improving still.what other i need to use in place of cursor
TSQL 101, SQL for Dummies, or any other TSQL book for beginners. Spend...
May 10, 2012 at 1:25 am
dwain.c (5/9/2012)
...Personally, I love playing with recursive CTEs, almost as much as I like being naughty, just to figure out how they work. 😛
I always hear people saying "stay away...
May 9, 2012 at 1:39 am
Interpreting the results from this isn't straightforward, at least not to me. I prefer the output formatted like this:
SELECT Strings, x.Goodchars, y.Badchars
FROM #t
CROSS APPLY (
SELECT SUBSTRING(Strings,n,1)
FROM (SELECT TOP (DATALENGTH(Strings))...
May 8, 2012 at 3:55 am
capn.hector (5/3/2012)
crookj (5/3/2012)
capn.hector (5/3/2012)
Ray K (5/3/2012)
ChrisM@Work (5/3/2012)
bopeavy (5/3/2012)
Ray K
EL Jerry (5/2/2012)
--------------------------------------------------------------------------------
bopeavy (5/2/2012)
--------------------------------------------------------------------------------
hypothesis
Hypothermia
hypochondriac
hypothalamus
Beta thalassemia
Beta release
windows vista
Windows ME :crazy:
Mighty Excrement
Coproheavy
May 4, 2012 at 8:28 am
SELECT MinutesDiff = ([Days]*24*60) + DATEDIFF(minute,[Days],@date)
FROM (SELECT [Days] = CAST(DATEDIFF(dd,0,@date) AS BIGINT)) d
😉
May 3, 2012 at 10:05 am
Ray K (5/3/2012)
ChrisM@Work (5/3/2012)
bopeavy (5/3/2012)
Ray K
EL Jerry (5/2/2012)
--------------------------------------------------------------------------------
bopeavy (5/2/2012)
--------------------------------------------------------------------------------
hypothesis
Hypothermia
hypochondriac
hypothalamus
Beta thalassemia
Beta release
Betta bilda
May 3, 2012 at 6:58 am
bopeavy (5/3/2012)
Ray K
EL Jerry (5/2/2012)
--------------------------------------------------------------------------------
bopeavy (5/2/2012)
--------------------------------------------------------------------------------
hypothesis
Hypothermia
hypochondriac
hypothalamus
Beta thalassemia
May 3, 2012 at 6:09 am
jblovesthegym (5/3/2012)
ChrisM@Work (5/2/2012)
jblovesthegym (5/2/2012)
ChrisM@Work (5/2/2012)
jblovesthegym (5/2/2012)
Not found, no.??
What's up?
Fellas,
1) The link was not present on my screen, possibly the result of being stripped out of the page by...
May 3, 2012 at 4:58 am
elham_azizi_62 (5/1/2012)
I wrote this code with alter table and add columns.but i need to replace this code with pivot and i don't know how to do it?pleas help me...
May 2, 2012 at 6:29 am
Lars Jensen (5/2/2012)
Impressed!Thanks a lot...
Anytime 🙂
May 2, 2012 at 5:11 am
SELECT
tt.*,
x.ExchangeRate
FROM TransactionTable tt
CROSS APPLY (
SELECT TOP 1 ExchangeRate
FROM RatesTable rt
WHERE rt.CurrencyPair = tt.CurrencyPair
AND rt.ValidFrom <= tt.TransactionDate
ORDER BY rt.ValidFrom DESC
) x
May 2, 2012 at 4:55 am
Lars, which version of SQL Server are you using?
May 2, 2012 at 4:47 am
jblovesthegym (5/2/2012)
ChrisM@Work (5/2/2012)
jblovesthegym (5/2/2012)
Not found, no.??
What's up?
May 2, 2012 at 2:31 am
jblovesthegym (5/2/2012)
Not found, no.
May 2, 2012 at 1:46 am
Viewing 15 posts - 6,331 through 6,345 (of 10,144 total)