RE: Results from 1 column of many records into comma list
Thanks Shalk and Frank!Your suggestions were great. I went with a modified version of Franks example.Dan
2005-01-20
backup
RE: Problem with CAST
Or you can eliminate the CASE altogether and do something like thisSELECT 'ST_GR' = RIGHT('0' + CONVERT(varchar(2),ST.GR),2)
2005-01-19
RE: Case Sensitive Select
Hopefully someone will know of system setting or other easier method. In case no one else thinks of anything, it seems to me you may have to do a fairly sizeable loop. I would suggest looping through each record and converting each character to ASCII. You can then use a running SUM of those ASCII […]
2005-01-11
RE: Date Ranges
From reading your post it looks like you want to know guests who will be in the hotel for at least one day between 8/1/05 and 8/10/05. It also looks like it doesn't matter when they will be checking out. Try the following query:Select <ColumnList> From <Table> Where ArrDate Between '08/01/05' and '08/10/05'
2005-01-04
RE: Modify WHERE clause in Stored Procedure
Hm, can you show me how to get this running?declare @open bit set @open = 0 SELECT * FROM orders WHERE shippeddate CASE @Open WHEN 0 THEN Is Null ELSE IS NOT NULL ENDServer: Nachr.-Nr. 156, Schweregrad 15, Status 1, Zeile 6 Falsche Syntax in der Nähe des CASE-Schlüsselwortes.
2004-12-21
RE: Adress interval into multiple records
create your new table (I'm assuming you know how to do that).insert into tNewTableName(ID, roadname, house_number)select ID, roadname, house_number_startunionselect ID, roadname, house_number_end
2004-12-21
RE: Modify WHERE clause in Stored Procedure
I would use a case statement in your SP. SELECT ID, TITLE FROM MyTable WHEREClosed_DateCASE @Open WHEN 0 THEN Is Null ELSE IS NOT NULL
2004-12-21
RE: Question of the Day for 21 Dec 2004
mmm.. I see and sysxLogins table in master with xdate1 and xdate2. Maybe we are checking the wrong table.JFB
2004-12-21
RE: DTS Export to a Specific Named Range in Excel
What exactly are you trying to do? If you are looking to export a single value to a cell you can use:e_wksheet.Cells(1,1).Value = yourvalueOr are you are looking to insert a complete column?
2004-12-20
RE: SQL code to combine 2 queries
Thanks for posting the code, David.When I tried to save it, I got thrown out of Access. I was careful to change the '[' around the 2 SELECT statements to '('. I am able to save the other queries that I have. What gives?Robert
2004-12-20
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers