RE: Need ActiveX Script To Rename A File
exec xp_cmdshell 'rename "\\tstsql01\d$\temp\ip.doc" "ipnew.doc"'
2003-12-22
1 reads
events
RE: variable tablename in cursor select stmt
What would be your max number of tables per @countyt? I'm thinking something in the line of (David's modified) declare @sql nvarchar(4000) set @sql = 'DECLARE cursor2 CURSOR GLOBALDYNAMIC FOR SELECT Convert(Int, 0) as SumOf_file_size_bytes , Convert(Char(x), NULL) as Lseries WHERE 1=2 -- Dummy to establish structure' + Char(13) + Char(10) Select @sql = @sql […]
2003-12-19
1 reads
RE: variable tablename in cursor select stmt
The number of tables are about 150 now and the number of rows anywhere from 0 to a million in each table. The number of tables and rows can increase in future as they get updated once a week/2 weeks. The table name has to be obtained dynamically since the it put together as tblFilenames_XY […]
2003-12-19
RE: Simplifying this select
Matt, I apologize again for the errors . Thanks for your patience. I hope I at least provided some things to help you and maybe others. Vacation is indeed long over due. It's to the point of "use it or lose it", which means I really need it. Hope I don't spend the entire vacation […]
2003-12-19
RE: ORACLE !
I have had the pleasure to work extensively on Oracle and SQL Server and thought this thread was great!! Yes, Oracle DBA's are more protective and I think the SQL Server DBA's could learn something from them. I used to be in a mixed batch of 11 DBA's and we had some of the most […]
2003-12-19
RE: Simplifying this select
Yes I noticed that, but I figured that out without your help. :] ALso your temp tables where messed up as well. Yes, you need a vacation. That gets me my data and got the right # of active_units. Only issue I see now, is I am only getting up to 2002 data no 2003 […]
2003-12-19
RE: Simplifying this select
It's getting close to vacation time 🙂 so my typing is getting rough :(.... last post I had "is" misplelled as "id". Please correct... It's hard to test some of these things when you don't have the core source tables. I'll stick with you though.
2003-12-19
RE: Simplifying this select
Let's try again... -- Make #EOMDates table If Object_ID('TempDB..#EOMDates') id Not NULL Drop Table #EOMDates Select * Into #EOMDates From ( Select Convert(DateTime, Convert(Varchar(8), DateAdd(m, 1-AMonth, DateAdd(yy, -ManyYears, GetDate())), 1)) - DatePart(d, GetDate()) As EndOfMonthDate From ( Select Number as AMonth From Master.dbo.spt_Values Where Type = 'P' and Number Between 1 and 12) Months Cross […]
2003-12-19
1 reads
RE: Simplifying this select
Sorry Matt, I had the WHERE above the JOIN in my initial post... anyway, let's splitup the complexity... -- Make EOMDates table If Object_ID('TempDB..#EOMDates') id Not NULL Drop Table #EOMDates Select * Into #Temp From ( Select Convert(DateTime, Convert(Varchar(8), DateAdd(m, 1-AMonth, DateAdd(yy, -ManyYears, GetDate())), 1)) - DatePart(d, GetDate()) As EndOfMonthDate From ( Select Number as […]
2003-12-19
1 reads
RE: Simplifying this select
Ahh I thought the first where statement was for the subquery and the 2nd where was for my original select, so I joined the 2 where's together and I am getting the same error message. ALso made a change to how I joined the tables together slightly. I also tried moving the On portion of […]
2003-12-19
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers