Viewing 15 posts - 1,576 through 1,590 (of 2,038 total)
Hi Paul
I tested both solutions and you are completely right with BIGINT (or BINARY in combination with a CLR). I see there is still much to learn for a non-DBA...
April 3, 2009 at 8:18 am
Hi Paul
1. Does it support AND / OR combined searches as in the posted examples?
It depends. For simple any-ORs sure you can use a join without the having-condition. For...
April 3, 2009 at 6:23 am
Don't shoot me, but I stopped using BEGIN-END in procedures since I noticed it has no effect. You can write as much BEGIN-END BEGIN-END blocks into a procedure as you...
April 2, 2009 at 3:31 pm
Hi
As I learned by my self (thanks to Barry 😉 ) the best way would be a combination of a xml transformation and stuffing of the result:
DECLARE @t1 TABLE (id...
April 2, 2009 at 3:22 pm
???
Either type:
[ code ]
HERE ENTER YOUR SQL
[ /code ]
(both code tags without the spaces)
or click the "[ code ][ /code]" link, set the cursor into the middle of the ][...
April 2, 2009 at 2:54 pm
Hi Timothy
Nice approach to handle it with a web-service!
As you previously posted:
... but I have more fun building!
If this is possible it is always the best solution!! 🙂
Greets
Flo
April 2, 2009 at 2:51 pm
Hi
The answer for the join type is: the INT column.
I would add the UserId instead of the DepId to the transaction table to avoid data redundancy. So you can use...
April 2, 2009 at 2:47 pm
Would you please tell me why I could not create a table with sample data in the table?
I don't really understand you. Open your Management Studio, type a valid CREATE...
April 2, 2009 at 2:32 pm
... and have a look for triggers on your table.
Greets
Flo
April 2, 2009 at 2:20 pm
RBarryYoung (4/2/2009)
That's true, except that you cannot use SMO from CLR in SQL Server 2005 (I believe that this is relaxed slightly in 2008).
Hi Barry!
Really? I must confess that I'd...
April 2, 2009 at 2:10 pm
Hi J-F!
As first: Maybe I'm currently don't get it, so sorry if I'm just now start writing nonsense :-), but...
You are absolutely right, QUOTENAME is a nice feature to quote...
April 2, 2009 at 2:02 pm
Hello josephptran2002
Maybe you better understand what the people want to tell you with your data.
Your posted sample data:
BODDS BOCLEARED BOCLEAREDDATE
BO 3 1/1/2009
BO 1 1/2/2009
BO 5 1/3/2009
Problem
Everybody who wants to help...
April 2, 2009 at 1:40 pm
Hi
Is it possible that your procedure parameter is restricted to length of 128?
I just tried with a 10,000 characters long VARCHAR and it works fine.
Greets
Flo
April 2, 2009 at 1:23 pm
Vijaya Kadiyala (4/2/2009)
it looks like you are passing dynamic WHERE condition and you are going to HIT boundary on the length. So why dont you...
April 2, 2009 at 1:09 pm
Viewing 15 posts - 1,576 through 1,590 (of 2,038 total)