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
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
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
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
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