Viewing 15 posts - 286 through 300 (of 2,452 total)
Luis Cazares (12/13/2016)
Apparently, Eirikur has the crystal ball.It took me a couple of harsh posts to make the OP confess and demonstrate Eirikur's statement.
you do wonder sometimes what people actually...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 13, 2016 at 9:42 am
suggest you use TRY_CONVERT...iirc it wont throw error but pass NULL instead on data that cannot be converted
CREATE TABLE #Invoice (Invoice_number NVARCHAR(10),
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 13, 2016 at 4:36 am
Welsh Corgi (12/9/2016)
What are my options?
bcp "SELECT Col1,Col2,Col3 FROM MyDatabase.dbo.MyTable" queryout "D:\MyTable.csv" -c -t , -S...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 9, 2016 at 10:10 am
what script did you use......?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 6, 2016 at 8:43 am
as an example....maybe something like this ?
CREATE TABLE somedata(
BoxID VARCHAR(2)
,BottleID VARCHAR(4)
,ItemCode VARCHAR(4)
,Batch INT
);
INSERT...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 6, 2016 at 3:33 am
robert.sterbal 56890 (12/2/2016)
J Livingston SQL (12/2/2016)
sorry I dont follow what point you are trying to make in this thread? Can you please explain for me. Thanks
I'd like to understand...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 2, 2016 at 11:39 am
robert.sterbal 56890 (12/2/2016)
robert.sterbal 56890 (12/1/2016)
How is the script licensed?
The Author:
Hi Robert
I do not have any problem someone using the script...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 2, 2016 at 11:18 am
sgmunson (12/2/2016)
sac.nan (12/2/2016)
John Mitchell-245523 (12/2/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 2, 2016 at 8:40 am
John Mitchell-245523 (12/2/2016)
J Livingston SQL (12/2/2016)
sac.nan (12/2/2016)
J Livingston SQL (12/2/2016)
WITH C1
AS (SELECT id,
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 2, 2016 at 7:19 am
sac.nan (12/2/2016)
J Livingston SQL (12/2/2016)
WITH C1
AS (SELECT id,
p2pid,
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 2, 2016 at 7:02 am
maybe...???
WITH C1
AS (SELECT id,
p2pid,
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 2, 2016 at 6:42 am
how are you intending to order the rows as you have shown? do you have other columns that can be used to guarantee the order?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 2, 2016 at 2:45 am
mack53nico (12/1/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 1, 2016 at 5:36 am
this is well worth a read......http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 1, 2016 at 3:24 am
robert.sterbal 56890 (11/30/2016)
http://opensourcecook.com/recipes-copyright-law
(I'm republishing the book: https://cookbooks.leannebrown.com/good-and-cheap.pdf as a set of wiki pages: https://sterbalfamilyrecipes.miraheze.org/wiki/Category:Good_and_Cheap_Recipes)
I needed permission to post the images, not...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 30, 2016 at 12:48 pm
Viewing 15 posts - 286 through 300 (of 2,452 total)