Can This Be Done? (n00b Question)

Apr 10, 2007

I am trying to do a group by and left join together but it does not seem to be working.

SELECT sb.[BrowserID]
,sum([BrowserTotal])
,[BrowserName]
FROM [IISLOG_REPORTS].[statistics].[browser] sb
left join [IISLOG_REPORTS].[lookups].[browser] lb on sb.browserid=lb.browserid
GROUP BY sb.[BrowserID]
ORDER BY sb.[BrowserID]

The above code works without the blue line there (which is being fetched from the lb table). Any suggestions for this? I would need all 3, including the BrowserName. Thanks

View 2 Replies


ADVERTISEMENT

Very Simple (n00b) - Db Backup?

Dec 8, 2005

Hey peeps, n00b here, in WAY over my head.

I have an MS SQL server running in the office, which is used for more than one application - the same server hosts databases for at least two totally seperate applications. One of these databases is called CApplication, and another iscalled CSystem, and these two together support an app called Client.

All I want to do is create CApplication2, which is an exact one-time copy of CApplication. I don't need it to update, or synchronise, or link to any other database, or anything. I want to write an interface for this DB, and I don't want to use the live one.

Do I "detach" then "copy" then "reattach" or something? If somebody could give me some rather lame step-by-step instructions I would really appreciate it - I can take this databasse offline, but I really should try to put it back online as soon as possible, and it is essential that nothing changes in between!

I'm a bit nervous about this, if I break this database I'm a dead man. Thanks guys!

View 2 Replies View Related

Sorry A Bit Of A N00B Question On Sql Syntax

Apr 20, 2007

Ive got a SQL database binded to my Visual studio studio 2005 proect i am creating



within this database i have the following table's



Employee: which contains instances of employer's

Manager: which contains instances of the managers

Till:- containst instances of til's





i want to write a query that selects certian elements from the till table, i thought it would have gone a little something like this





SELECT *

FROM Till

WHERE checked by = NULL



am i using the correct syntax?



any help would be appreciated





View 13 Replies View Related

N00b Question: Connecting To SQL Server At ISP?

Jul 28, 2005

Hey all, sorry for asking such a grunt question, and thanks in advancefor any help...My hosting ISP offers access to their MS-SQL database, and myunderstanding is that it's generally simplest to use some sort ofclient app to do stuff like adding tables and whatnot.SQL Server includes Enterprise Manager, but since my ISP is running theserver, I don't need my own copy of SQL Server, just the client.Any tips? I couldn't seem to find an appropriate download on theMicrosoft site...thanks again, -Scott

View 4 Replies View Related

N00b: Best Way To Import Flat File With BIDS

Oct 25, 2006

Hi all,


I'm totally new to SQL Server 2k5 and need to do something rather basic: import some CSV files into tables. I'm getting translation errors and would like to know what's the best way to cast the strings before inserts.

I'm doing the import in BI Development Studio.

Current situation:
Created connection managers to csv files
created SQL server destinations pointing to the tables
connected them directly with a dataflow path
Ran the packadge: one import went just fine, the other one complains about conversion errors like "Conversion DT_STR and DT_I4 not supported"


Both tables have the same kind of fields (varchar, float, datetime, int)

I looked at converting the data using a transformation but am somewhat confused of which one to use.


What's the best way to transform the data before insert: derived column, import column or data conversion? Or something else I overlooked?

TIA

Peter

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved