Viewing 15 posts - 4,861 through 4,875 (of 9,712 total)
jbalbo (1/13/2012)
Wow never picked it up!!
It's probably the most common sql server mistake ever made and everyone, even the experts, make it constantly. Just remember: If everything else looks correct,...
January 13, 2012 at 9:14 am
SQL Kiwi (1/13/2012)
What's the general feeling about asking Steve to remove that "Question for the Experts" thread? +1 vote here.
I was going to ask him to lock it.
January 13, 2012 at 7:14 am
Can someone who knows more about C# help out here?
He's passing code to SQL Server and not getting things to work. I'm half out of my depth and half too...
January 13, 2012 at 7:13 am
You've followed all the steps below?
January 13, 2012 at 6:46 am
HemSingh (1/13/2012)
Brandie Tarvin (1/13/2012)
I refer you back to my last response.Use IN instead of = on the stored procedure and concatenate the values together......
Hi Brandie Tarvin,
I am trying yr...
January 13, 2012 at 6:36 am
You say you set up DBMail, but did you set up Operators?
January 13, 2012 at 6:12 am
jbalbo (1/11/2012)
Hi,Getting a syntax error on the following..
INSERT INTO @TEMPTABLE(TAG_NAME,TAG_DATA)
SELECT TAG_NAME = 'CUST_AGE',
TAG_DATA = (SELECT FLOOR(DATEDIFF(day, BDate, CURRENT_TIMESTAMP) / 365.25))
FROM client
WHERE Client.OID =@CLIENT_OID);
To answer your original question...
January 13, 2012 at 6:10 am
I don't understand your question because it has no context. When you say "cluster" are you referring to data in a table or an actual SQL Server Cluster set up?
Please...
January 13, 2012 at 6:07 am
kwoznica (1/12/2012)
So what is the best way to enforce referential integrity? Should I add a constraint to the CaseData table?
You should be able to create a regular Foreign Key Constraint...
January 13, 2012 at 6:04 am
Let's go back to your original question.
What happened? Why do you need to read data from your log file?
And do you just want to read it or are you...
January 13, 2012 at 5:59 am
You can create a SQL Server job with a Transact SQL job step that runs your update code on a weekly schedule.
If you want more information, please post more details,...
January 13, 2012 at 5:53 am
I refer you back to my last response.
Use IN instead of = on the stored procedure and concatenate the values together. You can expand my single parameter query to...
January 13, 2012 at 5:51 am
sql Anand (1/13/2012)
is there any way to do this in...
January 13, 2012 at 5:14 am
This can be translated down to a T-SQL "IN" clause. You can have 1 or multiple values in an IN clause (as opposed to an equals "=" query).
The key would...
January 13, 2012 at 5:05 am
So far as I know, and I may be working off of old knowledge, instances cannot be renamed. They have to be installed brand new with a new name.
January 13, 2012 at 4:58 am
Viewing 15 posts - 4,861 through 4,875 (of 9,712 total)