i'm raising the summary tables by using the following query,
INSERT INTO ClientTbl_SummarySales…
1 year ago
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…
1 year, 1 month ago
Is there an equivilent function to Excel's 'CLEAN' in SQL to remove non printable characters?.
By: Luis Cazares
I'm having trouble with an insert statement that is throwing a duplicate error (shown below) o…
1 year, 2 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…
By: Jeff Moden
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, 4 months ago
Before deleting a record, i have to check whether the record exists in someother tables or not..
I was wondering if there is an alternative to running XP_cmdshell DIR.
Basically, I run…
1 year, 5 months ago
Has anyone got a way to identify which column is to blame when encountering error 'String or bi…
I have a cursor defined as such:
Declare GEProfit Cursor For
1 year, 6 months ago
Hi,I am not getting the checksum_agg and binary_checksum. I understood that it is used to detect ch…
1 year, 7 months ago
Viewing 15 topics - 16 through 30 (of 12,231 total)
You must be logged in to create new topics.