Viewing 15 posts - 40,186 through 40,200 (of 49,571 total)
Ok, so do you want them matched in order of the columns? So for output you want (first few rows only)
3191 3621004
3193 3621005
3340 3621006
3391 3621007
3392 3621008
3394 3621009
Correct?
Can I use a...
March 24, 2009 at 9:54 am
foxjazz (3/24/2009)
Are you guys saying it can't be done.
It can be done easily. It's a trivial problem. I'm just missing some information I need.
I don't know what your data looks...
March 24, 2009 at 9:45 am
So much for improving. Guess someone's going straight back on the blaclklist
March 24, 2009 at 9:28 am
angels4kali (3/24/2009)
The volume on device 'C:\PathToFullBackup\FullbackFile.bak' is not part of a multiple family media set. BACKUP WITH FORMAT can used to form a new media set. RESTORE...
March 24, 2009 at 9:23 am
foxjazz (3/24/2009)
being as sarcastic as possible, you may control the order if you wish. Maybe using order by??
Excuse me? I'm trying to help you here. Maybe you can take...
March 24, 2009 at 9:20 am
Please don't start a new thread for an existing problem, especially when you haven't answered the questions that have been asked in the older thread.
No replies to this thread please....
March 24, 2009 at 8:55 am
david.griswold (3/24/2009)
March 24, 2009 at 8:46 am
Edit: Crosspost
DT1 = select productcontrolid from productcontrol where productcontrolid > @max-2 - 25
What controls the order? What makes a particular row row 1, not row 13?
Basically, what I'm asking is...
March 24, 2009 at 8:40 am
YSLGuru (3/24/2009)
Where did you see this formula listed ofr getting the Start of the month?
I don't recall seeing it anywhere. The version to trim the time off a date is...
March 24, 2009 at 8:40 am
Kop_Eoin (3/24/2009)
So USE [dbname]GO
GRANT VIEW Definition TO [reader_role]
GRANT VIEW DEFINITION ON [database|schema|object] TO [role|user]
March 24, 2009 at 8:31 am
Roy Ernest (3/24/2009)
How many of you all travel to Europe for Pass?
PASS US if I can afford it (and it's an expensive flight from where I am). Fortunately I don't...
March 24, 2009 at 8:30 am
The database aspnetdb is set to autoclose. The close of the DB is causing the cache flush.
March 24, 2009 at 8:26 am
GilaMonster (3/24/2009)
Does the SQL Service account have access to it?
March 24, 2009 at 8:24 am
Converting to varchar and back is a poor way of getting the start of month. It's much slower than using date functions.
select dateadd(mm, datediff(mm,0, getdate()),0)
Then the formatting to not show...
March 24, 2009 at 1:44 am
Does the directory C:\Inetpub\vhosts\httpdocs\ exist? Does the SQL Service account have access to it?
March 24, 2009 at 1:38 am
Viewing 15 posts - 40,186 through 40,200 (of 49,571 total)