I am looking for a formula to trim exactly characters off the right side of a string. I am trying to convert an IDNumber field to a string. But no matter what...
Hi All, I'm working on tracking users that login to a web app with Sql Server and C#...I'm getting back the results that I need but I can't figure out to ...
Not sure if this is the right group... Kind of long...We are having some problems at one of our customers and we are trying to figure out what is going on. The...
I have some code I wrote in MS Access but when I convert it to MS-SQL It no longer functions Here is the SQL using MS Access ... SELECT ZipLocation.Zip,...
ADVERTISEMENT Hello.. I have a query that joins a couple tables together but one of the tables has a many to one relationship and I only want to pull in the ...
Ok..been struggling with this one for a day or so now. Please help if you can. This will join about 5 tables together. Here is the info... I need to create a...
Hi I have a table like below with many records that some of them are duplicated(same in CstID and PrdID) .I want to show this duplicated records. CstID...
Update. I found that a UNION ALL SQL will give me the combined results I want. Now, how do I do an join and a count on thse results to gve my the count by...
hello group, help me pleeease. a simple thing has given me stress. can anyone help me urgently pl?? i have got a simple table having, say 6 fields :this is a...
Hi, can anybody help me? I have one select statement with group by clause and i would like tu add one or some fields to it. Example: - warehouse table SELECT...
Occasionally I'd like to take a certain joined table structure and right outer join it (joined itself to, eg, perhaps a table of targetted or active clients)...
Good afternoon. Has anyone ever come across a SQL quick reference sheet? Not a book, but a page or two with most/all SQL commands with terse definitions?...
What's the correct syntax for creating a table with a select statement? Isn't it like "SELECT...FROM...INTO"? I don't need an insert statement. RR NOTICE:...
Hi,all Whats up? this is Navid here,wanna u guys to give a hand.i,m a developer u could call it.im in a deep blue so can any one help me out? to take me out u...
Hi - I have probably a rather simple question, but would like to understand the reasoning. I wrote a query selecting some columns from some tables, but one of...
Hi Mike, Not sure what you're asking? If it's about how to run automatically every half hour try the Windows Task Sceduler. You'll find it under My Computer as...
Hi, I run a Script File from the sql plus on the win 2000 client machine against the Oracle server v.8i that resides on the different machine: Script File is...
I'm not understanding the syntax for joins or virtual(alias) tables...for example where you say: SELECT ATTRIBX, ATTRIBY FROM EMP WORKER where WORKER is the...
Say if I have table with following fields Id LogInDate (DateTime) (not null) LogOutDate (Datetime) (not null) Constraints Logindate < Logoutdate Say this table...
I would like to customize a column header by specifying an alias in a "Select" statement using a variable instead of literal. My Select statements error every...
Hi, Your join is incorrecly specified. The joined tablename must follow the join keyword. Because it is a self join you will need to alis at least one one ...
I need to select the top record of each jobnumber I do a group by and order by and get them to the top of each group but how do I select just that first record...
Just realised last night this is illegal in TSQL, can't assign variables in the IF EXISTS query. ... IF EXISTS ( SELECT @RcptId = RecipientId FROM Recipients ...
