Viewing 15 posts - 4,876 through 4,890 (of 9,726 total)
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
Knowledge Hunter (1/13/2012)
My understanding is that I will ahve to get access for the SQL Server from someone who already has access to the SQL Server.
Yes, you will. Is there...
January 13, 2012 at 4:57 am
Viewing 15 posts - 4,876 through 4,890 (of 9,726 total)