Viewing 15 posts - 76 through 90 (of 92 total)
Wow, I started this for a completely different reason, and I've learned a ton just the same. To put it all together to make sure I've got some of this...
June 3, 2011 at 8:39 am
I think I understand your general idea here. If you don't mind I'd like to check what I'm getting from you. Instead of using...
Where IsDate(AdmitDate)=1
...you recommend...
Where IsDate(AdmitDate)=1
And AdmitDate...
June 2, 2011 at 1:39 pm
I don't have a choice regarding the date data type being set to Varchar. This was set up by our application developers, and they require all fields be set to...
June 2, 2011 at 7:30 am
Sorry for not making my goal clear enough. In short I am trying to iterate through several columns either on the same or multiple tables, and run an update on...
May 31, 2011 at 7:57 am
I'm getting stuck on how to script the tally version. This is what I have come up with, but so far it's a no go.
Declare @TableName Varchar(128),
@FieldName Varchar(128),
...
May 27, 2011 at 1:50 pm
I appreciate all of the ideas that have been shared on here, and I look forward to learning about the fundamentals of most / all of them. I thought I...
May 27, 2011 at 8:04 am
We receive the data in .csv format. Each state's Medicaid department, and the federal Medicare department are all standard unto themselves (in short 52 different formats). I have those pre-defined,...
May 25, 2011 at 11:43 am
I have used this code since I first began, and after a few years I have not changed it yet. I recommend keeping it on hand...after a while it will...
May 24, 2011 at 4:01 pm
WOW...THANK YOU!!!
I will start reading this right away. I'm glad to know you're on the boards here...both of you have already been a huge help!
May 23, 2011 at 2:13 pm
Excellent. I just IM'ed my wife to add it to the list / budget. I'll give it a go soon.
May 23, 2011 at 12:46 pm
Thank you Wayne. I'm looking at the Execution Plan now, and I can see there is a great deal more items in the 1st method's plan than there is in...
May 23, 2011 at 11:28 am
happycat59 (5/18/2011)
declare @sqlcum nvarchar(max)
set @sqlcum =N'insert into '+@tablo+N' (baslik,icerik,dilid) values('''+@baslik+ N''','''+@icerik+ N''','''+@dil+ N''')'
I'm sure this is a beginner question, but just the same...I see the letter N used every now...
May 20, 2011 at 4:11 pm
Btw, thank you for the link regarding the Tally table. That is already going to save a HUGE amount of time, and I only have scratched the surface on it.
I...
May 20, 2011 at 3:46 pm
I didn't catch what you did the first time around...that is brilliant!!!
I admit I am stuck on using loops too often. Part of why I'm on here is to learn...
May 20, 2011 at 12:41 pm
It's cumbersome, but it works. It is also scalable to any number of rows you need to scan.
If Exists
(Select *
From Sys.Tables
Where Name='A_Counter'
And Type='U')
Begin
...
May 20, 2011 at 12:24 pm
Viewing 15 posts - 76 through 90 (of 92 total)