Forum Replies Created
Viewing 15 posts - 2,461 through 2,475 (of 7,631 total)
-
RE: How can I convert this to sql
Krasavita (5/12/2009)
How can I write it at store procedure. Thank youFirst, is Add1 a column or a variable?
Secondly, we can not convert this to a Stored Procedure (which is like...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: indian authors for sql server book
[h2]Uurrrpp![/h2]
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: indian authors for sql server book
Done:
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: I was wondering if anyone could tell me where my syntax is wrong
The are two different formats for the CASE function:
1:CASE [valueExpr1] WHEN [valueExpr2] THEN [valueExpr3]
This format compares [valueExpr1] to the value expression after each WHEN clause and if true...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: Performance issue with tally solution
Jeff Moden (5/12/2009)If anyone knows what the ".VALUE trick" that UMG was talking about is, I'm all ears, thank you.
When you are using FOR XML to do string concatention,...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: Package to Import exact same structures from 1-4 different databases
Shawn Therrien (5/12/2009)
Okay, that sounds easier than I thought. Just do the import for one, but make sure you're using the Package Configuration to store all the variables like server...[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: Package to Import exact same structures from 1-4 different databases
Hmm, Im not sure, actually...
What I was talking about is one package with a source CM (connection manager) pointing to one of your four sources and sending the data to...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: Mainframe and SQL Server
Actually, I have seen perfectly valid reasons for having both the extracted subfields and the whole address as originally input.
The crux of it is that addresses are notoriously dirty, mangy...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: Are the posted questions getting worse?
Bob Hovious (5/12/2009)
Snoop with a banjo??The tune is original, like the lyrics. I'm making this up as I go along. 😉
Well I can only read the words...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: Package to Import exact same structures from 1-4 different databases
I don't know about any GUI for the user, but as far as retargeting an SSIS package, that is usually done through Configurations. I do this all the time,...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: ROW_NUMBER(): An Efficient Alternative to Subqueries
UncleJimBob (5/12/2009)
I have seen similar examples of ROW_NUMBER() usage and the following has always puzzled me:Why do we include columns in the ORDER BY when they are already in the...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: Are the posted questions getting worse?
Bob Hovious (5/12/2009)
...You know I love the ladies: silver, gold, blue or green,
Hot pink, fluorescent purple, and some shades in between.
I charm them and disarm them, if you know...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: Execute SQL job based on trigger file
Glad I could help!
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: Finding Page Splits
GilaMonster (5/7/2009)
Lynn Pettis (5/7/2009)
You can query the t-log??Yup. Undocumented command.
SELECT * FROM fn_dblog(null, null)Dang. That's amazing, Gail. :w00t:
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
RE: CALL PHONE from SQL Stored PROC/ Alerts
You can do this, either with specialized Software and Hardware (actually, you may not need the HW anymore), or alternatively, I beleive that there are psecialized services on the Internet...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 15 posts - 2,461 through 2,475 (of 7,631 total)