Viewing 15 posts - 7,156 through 7,170 (of 15,381 total)
Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1483780-1550-1.aspx
August 13, 2013 at 9:51 am
njdevils39 (8/13/2013)
August 13, 2013 at 9:50 am
mario.rbrandao (8/13/2013)
How to identify if the first word is the foundation or bank bring full name with t-sql?
Huh???
August 13, 2013 at 9:44 am
jamesheslin123 (8/13/2013)
August 13, 2013 at 9:43 am
kanchankalra85 (8/13/2013)
Sean,As of now, i have directly embedded the code to send the email to user in the trigger and am not calling a stored procedure..
Umm...
You are calling...
August 13, 2013 at 9:13 am
Gerard Silveira (8/13/2013)
The issue is I have a 4 part naming here, so Im looking for a method to move from PROD - TEST and TEST -...
August 13, 2013 at 8:52 am
garyh2k3 (8/13/2013)
Thank you both for your responses. I was able to educate myself a little more about the sp_executesql and it is now behaving as I need it to.
Happy...
August 13, 2013 at 8:20 am
kanchankalra85 (8/13/2013)
The trigger checks the count of records in the parent table. If the count is greater than a specified number; it sends an email to...
August 13, 2013 at 8:11 am
kanchankalra85 (8/13/2013)
Can someone please explain what is the purpose of execute permission? What is the drawback of granting execute? Does it cause lot of performance overhead or does it...
August 13, 2013 at 7:43 am
Or you can cast your datetime column as date.
WHERE cast(orderdate as date) BETWEEN '01/01/2000' AND '01/03/2000'
August 13, 2013 at 7:38 am
You do know that the 3 part naming convention is only a way to identify which object you are referring to right?
In other words, your request contradicts itself. You are...
August 13, 2013 at 7:32 am
Thanks for posting ddl and readily consumable data!!! I wish more people would post like that.
PIVOT can cause some performance issues so I generally try to avoid it. Instead I...
August 13, 2013 at 7:27 am
Gerard Silveira (8/13/2013)
Im looking for suggestions that would enable me to create a TEST environment.
AT this point in time in my PRODUCTION system , I have stored procedures...
August 13, 2013 at 7:20 am
RedBirdOBX (8/13/2013)
If it helps with suggestions, this is an internal app - the data will never be exposed to the outside world.Thanks!
You mean never intentionally. 😀 You need to store...
August 13, 2013 at 7:07 am
SQL_Surfer (8/12/2013)
ClientNo ItemCode NewPrice PriceChangedDate
11234 ...
August 12, 2013 at 10:03 pm
Viewing 15 posts - 7,156 through 7,170 (of 15,381 total)