Thanks for the response Code/Roji. I actually used the cursor based method, inserted an IDENTITY column along with a clustered primary key and all...
Hello Friends, I have the following stumper: I have a flat file with a couple of million records in a format similar to this: 1:, NULL...
Your sample input is a bit ambiguous. Could you post what the sample output should look like given your example? Do you want your output to look...
I was trying to see if there was a way to do it with UNION, but I don't think there is, but Frank's solution is correct: CREATE TABLE X (COL1...
Can you post the SP and any dependencies? Since you need it in 1 TSQL step, it may be easier to implement a solution within your stored proc. I am...
One of your owners in your database is most likely missing or the database owner's Windows account has been deleted. The following query will give...
You could also use DBCC SQLPERF(LOGSPACE)
Total diskspace is 10MB?!? You need to backup your DB log using the "WITH TRUNCATE_ONLY" command if you want to delete all entries. WARNING, this...
Yes, of course. As long as there is a candidate key in the table that it is referring to. You may want to read up on foreign keys or google it to get...
CREATE TABLE #TEMP<br />(ID SMALLINT IDENTITY,<br />DATA NUMERIC(2))<br />go <br /><br />INSERT INTO #TEMP VALUES (16);<br />INSERT INTO #TEMP VALUES...
sp_helpdb might be a good start. You could also use the script below to get some of the information that you need: SET NOCOUNT ON -- Database...
Try the following: This assumes that your City has no spaces and the format is as you mentioned it to be CREATE TABLE MyTable (CSZ VARCHAR(100))...
I would suggest leaving your screen prints intact so that anybody can recover them. A disaster scenario can happen regardless of a DBA being present...
From what you have posted, you are not using any loops to cause an infinite loop. Is this the entire code or are there other pieces that get called...
Is your query returning what you need it to return? If not what result are you expecting and what needs to be "corrected"? The 1st submission on...
quote:Originally posted by EasySQL Your code is working great with the following changes.You have to use day rather than dd give the date range a...
I am assuming by "0 hours" you mean 12 AM midnight and also that you need it between 2 days. Try this in your WHERE clause ... WHERE...
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
Could you be a little more descriptive with the problem scenario. I am guessing it is an I/O error. Check the disk space and see if it is full. BTW,...
Post the entire stored procedure so that we can get a better idea of exactly what you are trying to accomplish
Separate names with a comma.
