Topics
Started by
Posts
Last post
guys, using select statement how can i search for a field that contains the '%' string? It g…
2 replies
How can I link the following ? SELECT OFFERITEMS.UNITPRICE FROM …
1 replies
iam from india, and our date format is dd/mm/yyyy yesterday when our operators were making invoice …
4 replies
hi all i have a cursor that is populated with before and after dates whilst looping through the cur…
2 replies
The first 2 queries work (obviously) but the third will not accept [b.investID] as a parameter. Any…
4 replies
Hi, I am new to T-SQL and I have the following problem to solve. I have a table (TestInput) w…
4 replies
I'll try to reduce this to the simplest possible form to make the point easier to understand. …
2 replies
Hello, Is it possible to use the system tables to create a sort of data dictionary? I'd like …
9 replies
I have the following query: SELECT COUNT(jsl.jslid) AS totalleads, CAST((CA…
6 replies
Hey, I'm having some trouble trimming white space off the end of an nVarchar text field. If I try a…
5 replies
All, Has anyone ever tried to compute business hours between two given date/times? I've found a lot…
4 replies
I have (inherited a) a db with lots of tables looking like the definition at the end of the message…
2 replies
Hello everyone and THANK YOU for this site. I have learned so much from it. M…
10 replies
I'm a bit braindead today and this has been burning my already overtaxed brain cells. Environment i…
4 replies
We have UPPER() and LOWER() but SQL Svr 2k does not have a function to put strings into their prope…
6 replies
Viewing 15 topics - 12,811 through 12,825 (of 17,082 total)
You must be logged in to create new topics.