Search results for query: *

Has anyone found a way to automate getting the web traffic data generated by Google Analytics into a SQL table. There is no ftp option within GA, only an automated email, which supplies an attachment containing the report in pdf or csv format. There are a few loose ideas I have, but I don't...

Has anyone managed to write to the NBUser table? We want to batch update/correct the user departments, titles etc, but the only way we can see to do it so far is by using the web client for a one by one horrendous manual process. We can view the table but can't write to it using the sysadmin...

Done it now, thanks I created a new table with the structure I wanted including the new fields, then did a SELECT INTO and renamed the new table with the old name

I am running SQL Server 2000. I have a large table of several million records. All I want to do is to add a new column, so I go to table design, insert a new column, put in the column name and change the type to int. Then when I hit save it just hangs. Egg timer. I have left it for 2 hours...

I am using SQL Server 2005. We have a dozen linked servers, which I can use a SELECT query fine to access the data and I can run the system stored procedures EXEC sp_catalogs 'LinkedServerName' & sp_tables_ex LinkedServerName fine to see what is in the Server/db. The problem I have is that...

I solved the time problem, it was because i needed to put HH:mm:ss instead of hh:mm:ss However, the dates swapping around I haven't solved. This only happens when previewing the report in Visual Studio. When I change the parameters on the report server web interface it works ok.

I have stored procedures, which display data perfectly in 15 minute interval blocks eg 17 May 2009 00:00:00 17 May 2009 00:15:00 17 May 2009 00:30:00 etc etc However, when I run the report in Reporting Services the 00 has changed to 12 eg 17 May 2009 12:00:00 17 May 2009 12:15:00 17 May 2009...

I have dozens of jobs that run overnight to pull back data from a few separate databases. They have been running for a few years, with very little trouble at all. They always succeed. Now suddenly, last night one of the jobs failed. Only one job. How can this suddenly happen? I ran the DTS...

OK thanks Is it the same if it was this scenario... Script xxx says QUEUE TO SKILLSET aaa WITH PRIORITY 1 and script zzz says QUEUE TO SKILLSET aaa with PRIORITY 2. If there is a steady flow of calls coming into xxx, and one call came into script zzz, would the zzz call never get answered...

Been a while since I have done scripting so this may be an easy one for you to answer. Script xxx says QUEUE TO SKILLSET aaa WITH PRIORITY 1 and script zzz says QUEUE TO SKILLSET bbb with PRIORITY 2. If there is a steady flow of calls coming into xxx, and one call came into script zzz, where...

Thanks for the reply. It's a set of skillsets. Only two of them though. How would you compile the syntax for listing the skillsets individually? I tried using AND but couldn't get the syntax right. (I haven't scripted for >1yr but am helping somebody out who is fairly new to it...)

iAgentBySkillsetStat? I haven't had a good look at the fields but I'm sure that'll do it...

We have recently upgraded to CC6 and have discovered a loss of functionality. In our master script we had a command ---------------------------- IF OUT OF SERVICE SkillsetGroupA THEN EXECUTE SCRIPT Script1 END IF ---------------------------- SkillsetGroupA is a skillset variable that contains...

I'm not sure, pronei, I don't have access to the server itself, only to the database. The engineer has finally accepted there is a problem, when these 2 days were also found to be missing on the standard Historical reports (Others > Application Performance > Check All Applications > Data Range...

We have CC6 and we do not use the standard historical reports. Instead we connect to the database and write our own queries against it. We have 2 days - 10th and 12th June - where there is no data in the dApplicatonStat view, but there is data in the iApplicationStat view. Anyone got any...

I don't think I'll bother trying to cleanse those user errors. There are all kinds of bizarre stuff, like Ffynonwen 14cv214ex 12PenybrynRd However, after scrolling through randomly these are probably less than 1% of all records, maybe even 0.1% so I think we can live with these

Have an extra big gold star if you can see a way around where the user has input a damn city name in the postcode field!!! :D

Thanks PDreyer I'll try that first and foremost

I'm writing a query on SQL Server 2005 to export a dataset to a CSV text file, in order to send the data to an external client, as our dataset is forming part of a bigger national project and they have strict requirements that it must be in this format. You think I should just do a find and...

How do you mean? I cannot alter the original database