Viewing 15 posts - 22,051 through 22,065 (of 26,490 total)
Please confirm that the purpose of the function is to return a table of items from a delimited string.
For example, given the string "'A','B','C','D','E'" return the following:
1 A
2...
March 11, 2009 at 3:43 pm
Here is my .02. I'd prefer to do native backups to local disks, then backup the backup files to tape or other remote storage media. Reason, it is...
March 11, 2009 at 12:53 pm
Nice it would be if feedback OP would provide.
March 11, 2009 at 11:58 am
Check out the following code and see if it does what you need:
select getdate(), dateadd(wk, datediff(wk, 0, getdate()) - 1, 0), dateadd(wk, datediff(wk, 0, getdate()) - 1, 0) + 4
March 11, 2009 at 11:56 am
GilaMonster (3/11/2009)
Roy Ernest (3/11/2009)
I think we have good one here...Let us see if he comes back with a positive answer or not.
Bet you a coffee that either he comes back...
March 11, 2009 at 11:27 am
Any response would simply be a guess. We don't have enough information to really tell you anything. We don't know how the data is partitioned and indexed, or...
March 10, 2009 at 3:28 pm
And, just for S&G's here is another alternative:
CREATE TABLE #Test
(ID INT, Countries CHAR(2));
INSERT INTO #Test
...
March 10, 2009 at 3:22 pm
Lynn Pettis (3/10/2009)
Flattery is imitation. Two Vaders there is on SSC.
Effort worth expending not.
March 10, 2009 at 2:22 pm
Here is another possible solution:
CREATE TABLE #Test
(ID INT, Countries CHAR(2));
INSERT INTO #Test
(ID,...
March 10, 2009 at 2:14 pm
Flattery is imitation. Two Vaders there is on SSC.
March 10, 2009 at 1:43 pm
Wonder I do should I correct him? 03:00 - 04:00 night is not, but early morn.
March 10, 2009 at 1:42 pm
I would not look at shrinking tempdb. I'd look at increase the size of tempdb so that when it starts it has the space needed to meet the processing...
March 10, 2009 at 10:55 am
How about the following:
DECLARE @InvoiceDate DATETIME
DECLARE @Ans AS VARCHAR(12)
SET @InvoiceDate = '2-29-08'
SET @Ans = CONVERT ( VARCHAR(12) , @InvoiceDate , 105 )
SELECT @Ans
SET @Ans = CONVERT...
March 10, 2009 at 10:49 am
I think you will find that the SQL Server 2005 version of the UDF I wrote will work just as well. It may even be more efficient as I...
March 10, 2009 at 9:57 am
I would start by reading ALTER DATABASE in Books Online (BOL). If, after reading that you still have questions just come back to this thread and ask for what...
March 10, 2009 at 9:29 am
Viewing 15 posts - 22,051 through 22,065 (of 26,490 total)