Viewing 15 posts - 45,721 through 45,735 (of 59,063 total)
jacowess,
Look at my previous post and look at your original post. If that's what you're actually running, you have syntax errors in the code.
January 20, 2009 at 5:34 am
Jacob Luebbers (1/19/2009)
Jeff Moden (1/19/2009)
January 20, 2009 at 5:23 am
munishprathap (1/19/2009)
according to my requirement i need to keep the one column type as bigint but unfortunately
i keep it as DateTime after long time i found that it was...
January 20, 2009 at 5:19 am
smunson (1/19/2009)
After 30 years of having to find ways to get data in or out of computer systems for almost every conceivable purpose, what I've found is that in every...
January 19, 2009 at 8:30 pm
mohinidba (1/18/2009)
can not open the following files
t;\michrosoftsqlserve\mssql.1\mssql\data
all of the data files of the system dbs and user dbs.
and the...
January 19, 2009 at 7:54 pm
Ummm... what happens when you run just the SELECT?
select NonEmpty [Tests].[Fixed] on columns,
from Cube
where ([Test Date].[Date].&[2009-01-16T00:00:00]
I'm thinking that you have some illegal text in the where clause and you're missing...
January 19, 2009 at 7:46 pm
This problem occuring in only one table and situation occurs with only records already existed in the database.
How do you know the records already existed in the database? And,...
January 19, 2009 at 7:43 pm
sal527 (1/19/2009)
Thanks to all, the issue has resolved and i am sorry as i could not reply at the same time.
Two way street here, chum... would you mind telling...
January 19, 2009 at 7:40 pm
This is absolutely the wrong thing to do. Dates should not be stored as integers.
What are the business rules stating that you should convert the column from a DATETIME...
January 19, 2009 at 7:36 pm
Perhaps pre-aggregated and dynamic crosstabs would help a bit...
http://www.sqlservercentral.com/articles/T-SQL/63681/
http://www.sqlservercentral.com/articles/cross+tab/65048/
I've had a lot of success with the combination.
January 19, 2009 at 7:31 pm
If someone else is doing the same thing and are in the process of modifying data, there may be an open transaction that is locking the table and no timeout...
January 19, 2009 at 7:27 pm
Aren't there about 10 million articles on how to break pwdencrypt() ?
January 19, 2009 at 7:23 pm
No need for a variable, at all...
SELECT SiteName
FROM db2.dbo.Customer c2
INNER JOIN db1.dbo.Site s1
ON c2.SiteName = s1.Debnr
WHERE s1.Name...
January 19, 2009 at 7:22 pm
All of that information is available in Books Online, as well.
January 19, 2009 at 7:15 pm
Viewing 15 posts - 45,721 through 45,735 (of 59,063 total)