Topics
Started by
Posts
Last post
Hello, I have a column which is integer data type and it represents number of seconds. I need to co…
19 replies
I have a query below which gets data for a mailing list to be generated. What I need to know …
1 replies
By: Sue_H
Hi, i'm raising the summary tables by using the following query, INSERT INTO ClientTbl_SummarySales…
8 replies
Hi If I have 2 tables tbl1,id(varbinary(18)AS PK) and tbl1, having id(varbinary(18)AS PK) can I joi…
2 replies
Hi, Is there an equivilent function to Excel's 'CLEAN' in SQL to remove non printable characters?. …
47 replies
All, I'm having trouble with an insert statement that is throwing a duplicate error (shown below) o…
16 replies
I need to update a table in a MySQL linked server from SQL2K5. This worked the first time or two I…
8 replies
I want to update a table's column data with serial number i.e. first row 1, 2nd row 2, 3rd row 3 et…
15 replies
Does anyone know where I can get examples, resources or a good books for SSIS?
9 replies
hi i want to find count of rows in all tables in database based on created thanks in advance, Pra…
12 replies
Hi, Assuming that the week starts from Sunday and ends on Saturday,can anyone provide me with a que…
9 replies
Before deleting a record, i have to check whether the record exists in someother tables or not.. ne…
14 replies
Hi experts, I was wondering if there is an alternative to running XP_cmdshell DIR. Basically, I run…
54 replies
Hi, Has anyone got a way to identify which column is to blame when encountering error 'String or bi…
28 replies
I have a cursor defined as such: Declare GEProfit Cursor For Select ILINVN , ILODPX , ILORD…
5 replies
Viewing 15 topics - 46 through 60 (of 12,230 total)
You must be logged in to create new topics.