Search results for query: *

I am seeing the below message in the log file. The only reference I can find about it points to a bug. The link provided confuses me more. I do not know what happened, I have just inherited this database and the entire error log file contains this message. I have not seen any other issues. Do...

MySQL can not handle named parameters, when I use ' ? ' the query works fine. This is when using ODBC.

hi all has anyone succesfully goten RS to work with MySQL? I can get basics to work, but I keep failing when I try to use parameters. the stuff I have found on the web has not been helpful... any suggestions or help would be greatly appreciated. thanks in advance.

they want to look at say.. a calendar view of this month and have the current month/year sales on the correct date and the sales from last year to display also, but they have to match up by Monday, Tuesday... ect. I know... clear as mud.

thanks Paul I am using SQL Server. You got me thinking in the right direction. I think I might look at the Calendar control from Dundas, not sure how else to do this in SRS select datename(weekday,dateadd(dd,-364,convert(char(10),getdate(),121))) ...

hi all I need to do a sales summary report that displays a figure for today Tuesday the 3rd and if possiable the Tuesday from last year that is as close to the 3rd as possiable. The ultimate results would be a calendar like display that has sales for 2007 and 2006 by day (Monday, Tuesday ect)...

Thanks to the both of you :)

Thanks George. Will the new attached datbase have a size limit or is it now fully a 2005 database when using the attach method? If that works, I would guess that using a backup of an msde db to do a restore to sql2005 might fully upgrade the db also.?

hi all is it possiable to upgrade an msde db on one pc to sql 2005 on a different server? or is the only path to do an inplace upgrade. much thanks

Hi all Is is possiable to copy data from Server A (MySql outside of firewall, internet) to Server B(SQL Server, inside firewall, intranet) using DTS? What I need to do is copy all of the data in tables from Server A to Server B then delete all data on Server A. This needs to happpen like...

Server A is the external internet web server, Server B is internal (intranet), Not exposed to the internet and behind the firewall. I need to move data from Server A to Server B then delete the data on Server A. This needs to be done all day long.

Hi all Is is possiable to copy data from Server A (outside of firewall) to Server B(inside firewall) using sql? What I need to do is copy all of the data in tables from Server A to Server B then delete all data on Server A. This needs to happpen like every 5 minutes. Both servers will be v5...

hi all I need to insert client records from a csv file into multiple tables. the client table creates the pk,clientId. how would I go about getting that clientId to insert the remainder of the records into different tables? if you could point me at an example of similar code or instructions I...

what i want to do is copy data from the server outside the firewall to the server behind the firewall then delete the data on the server outside the firewall. i was hoping to write a proc to do this.. or use some other tools. i just haven't found a way to do this like i can with sql server. thanks

Hi all Is there a way to link 2 mysql servers (5.0 and 4.xx) like you can do with sql server? One of the mysql server is "inside" the fire wall and the other is "outside" of the fire wall. Much thanks ;)

thanks, i rolled it up into one trigger.

Hi all Is it possiable to write one trigger that handles inserts and updates ? my table has has 2 fields, Id and Description. When a new record is inserted my trigger does an insert of this record into table B. That works fine. When a record in table A is updated I want the trigger to update...

They would like it to be close to realtime, the stores send information to the main DB server once an hour. I have never worked with Replication, and limited simple use of DTS. Not real sure where to begin on either. thanks

Hi all We are using sql 2000 standard and want a cheap solution to move reports off of the production(retail transactions) DB to another DB created just for reporting. Staying with the standard edition is Replication the best solution? Any suggestions/pitfalls would be appreciated. Thanks ;)

got it, Thanks Denis select case when path like '/%/%' then left(substring(path,charindex('/',path)+1 ,len(path)),charindex('/',substring(path,charindex('/',path)+1 ,len(path)))-1) else substring(path,2,30) end from catalog