Viewing 15 posts - 1,156 through 1,170 (of 2,038 total)
Depends on the requirement. Adi's solutions is a good way to have a online ranking. If you just need this statement once you can also use the RANK function:
DECLARE @TestRank...
May 1, 2009 at 5:17 am
BOL topic "CREATE FUNCTION" shows many different examples for "inline table-valued functions" and "multi-statement table-valued functions"
May 1, 2009 at 4:52 am
In SQL
DECLARE @sql NVARCHAR(1000)
SELECT @sql = 'SELECT * FROM dbo.Tally WHERE N < @N'
EXECUTE sys.sp_executesql @sql, N'@N INT', @N = 4
EXECUTE sys.sp_executesql @sql, N'@N INT', @N = 3
On client side...
May 1, 2009 at 4:35 am
Paul White (4/30/2009)
Florian Reischl (4/30/2009)
Why? Is my English SO bad? :doze:
Flo, Ihr Englisch ist viel besser als mein Deutscher!
Hmm. Babel fish - obviously. Isn't Ihr rather formal? ...
May 1, 2009 at 4:22 am
Lynn Pettis (4/30/2009)
Florian Reischl (4/30/2009)
Hi LynnNo. It's just a dictionary but the greatest I know (already 200,000 request within the last two hours).
Why? Is my English SO bad? :doze:
Heck no!...
May 1, 2009 at 4:18 am
john.arnott (4/30/2009)
By the way, your English is very good -- I hope you were kidding when you asked if it's "that bad".
I would say it was a little bit of...
May 1, 2009 at 4:11 am
Hi Lynn
No. It's just a dictionary but the greatest I know (already 200,000 request within the last two hours).
Why? Is my English SO bad? :doze:
April 30, 2009 at 5:55 pm
Hi John
I'm quiet sure that English is not her/his first language (due to the "Ja" I think he is German) but this is not the problem. I would never finger...
April 30, 2009 at 4:58 pm
"Heave ho"
Sorry, I cannot help but maybe somebody of the gurus just oversaw...
Greets
Flo
April 30, 2009 at 4:40 pm
I saw that you are new here so you are very welcome 🙂
Did you consider my other suggestion?
April 30, 2009 at 4:23 pm
Sorry, forgot:
For future posts it would be great if you encapsulate your source code into code tags:
[ code ]
YOUR SQL
[ /code ]
... without the spaces.
This makes it much more readable...
April 30, 2009 at 4:12 pm
I know, some people here will beat me for this, though...
Since your procedure looks more like a export-import tool and you have already a C# application. Why don't you connect...
April 30, 2009 at 4:10 pm
Hi
I'm not sure if this is the best approach but it's definitely a geek-toy:
Copied and pasted from BOL (search for sp_addlinkedserver):
--Create a linked server.
EXEC sp_addlinkedserver txtsrv, 'Jet 4.0',
...
April 30, 2009 at 3:54 pm
New non off topic for this thread...
http://www.sqlservercentral.com/Forums/Topic706693-361-1.aspx?Update=1
April 30, 2009 at 3:51 pm
Viewing 15 posts - 1,156 through 1,170 (of 2,038 total)