I have a stored proc that calls a web service via WinHttp.WinHttpRequest.5.1. For years, I …
1 year ago
I have XML data store in Sql table. XML structure will not be static.i want write the T-sql Cod…
1 year, 1 month ago
Where does the Alias reside when using a CASE Statement?
I have tried a couple place…
1 year, 2 months ago
I have a column which is integer data type and it represents number of seconds.
I need to co…
By: Jeff Moden
I have a query below which gets data for a mailing list to be generated. What I need to know …
1 year, 3 months ago
i'm raising the summary tables by using the following query,
INSERT INTO ClientTbl_SummarySales…
Is there any way to calculate XIRR in SQL server using T-SQL.
If I have 2 tables tbl1,id(varbinary(18)AS PK) and tbl1, having id(varbinary(18)AS PK) can I joi…
Is there an equivilent function to Excel's 'CLEAN' in SQL to remove non printable characters?.
1 year, 4 months ago
By: Luis Cazares
I'm having trouble with an insert statement that is throwing a duplicate error (shown below) o…
1 year, 5 months ago
I need to update a table in a MySQL linked server from SQL2K5. This worked the first time or two I…
By: John Hunter-389450
I want to update a table's column data with serial number i.e. first row 1, 2nd row 2, 3rd row 3 et…
Does anyone know where I can get examples, resources or a good books for SSIS?
i want to find count of rows in all tables in database based on created
thanks in advance,
Assuming that the week starts from Sunday and ends on Saturday,can anyone provide me with a que…
1 year, 7 months ago
Viewing 15 topics - 16 through 30 (of 12,231 total)
You must be logged in to create new topics.