Topics
Started by
Posts
Last post
OK my guru friends, I have a little problem, how can set a date as a wild card. Example - I have n…
10 replies
By: Maique
Hi, I want to add a column to a existing view, but the underlying tables doesn't have that column. …
4 replies
I have a query where I am trying to do multiple joins to the same table. If one of the rows in the…
4 replies
The title just about says it all. I tend to open 8 or more connections every morning when I get in …
8 replies
By: GSquared
Hello Everyone, I have a table 'employee' with 3 columns, EMPNO, HRS_WRKD, PAYCODE_NAME I run the f…
1 replies
By: RubyRed
Hi, How to write query in which I need to identify the last the row from the records? Thanks, SS
13 replies
The following query worked fine in MS Access (of course the apostrophes were hashes "#"). SELECT DI…
2 replies
By: RubyRed
hi guys i have a question, I have a stored procedure which takes 45 seconds to run when i do an EXE…
1 replies
By: GSquared
Hi all I am currently have a requirement to run some code against each table in a database and was …
1 replies
By: noeld
Hello All. I would be greatful for some assistance. I am trying to RANK a calculated metric and whe…
2 replies
By: GSquared
I want extract Column info for the first three columns in my table: Is it a Primary Key? What is th…
19 replies
Good Morning, everyone: I'm trying to join two tables. However, I only want to return the TOP 1 row…
7 replies
I have a CRM database where I would like to allow the user to enter 'A%' and have the search query …
3 replies
I'm kind of in doubt about a query I'm thinking and I'd like to ask for your opinion. I'd appreciat…
1 replies
As some of you may know, I've only been working with SQL Server 2005 for about 6 months now. I kno…
26 replies
Viewing 15 topics - 9,616 through 9,630 (of 12,230 total)
You must be logged in to create new topics.