Viewing 10 posts - 1 through 10 (of 10 total)
Is this also supported in SQL Server 2005?
Lowell (7/20/2011)
http://msdn.microsoft.com/en-us/library/ms187928.aspx
if your original datatype is money, then one of the overloaded parameters of the CONVERT...
July 21, 2011 at 6:03 pm
awesome...It works now. Thanks.
April 19, 2011 at 8:27 am
When I put the collate in front as you suggested, I don't get any sales_ID. No records. Nothing, nata.
ChrisM@home (4/18/2011)
April 18, 2011 at 3:32 pm
ChrisM@home (4/18/2011)
Jeff's posted an updated version of the string splitter here.I usually stream the results of a string-splitter into a #temp table then use that in the main query.
I am...
April 18, 2011 at 1:11 pm
This is the problem. I have a stored proc that is called by an application with parameters as a list. I need to have this stored proc create...
April 18, 2011 at 11:45 am
I tried this, not working.
DECLARE @SaleDate datetime;
SET @SaleDate = GETDATE();
EXEC dbo.GetSales @SaleDate, '''Outer Wear'', ''Mens'', ''Foot Wear'', ''N/A''';
GO
DB table has data.
If hard code it like this:
a.
category in...
April 18, 2011 at 10:15 am
Columns in table a are a.key
Columns in table b are b.key and b.date
Columns in table c are c.key and c.date
What I need to do is replace a.key...
January 27, 2011 at 7:17 pm
do I have to write a stored procedure for this?
January 27, 2011 at 6:27 pm
Can someone provide a SQL Server syntax to do this kind of update? Please really urgent.
I can't link the server. Can I use openrowset function? Helpful...
January 27, 2011 at 12:58 pm
How do you check if the servers are setup as linkedServers?
January 27, 2011 at 12:38 pm
Viewing 10 posts - 1 through 10 (of 10 total)