Topics
Started by
Posts
Last post
HI All, I'm trying to import MS Excel data into table using stored procedure. In the stored procedu…
5 replies
Hi all, We have a huge database sets, where members are given continuous running number from 1 t…
1 replies
Each of my clients has its own database with all of the same obects. I often have to query data for…
4 replies
I'm defined Date Only and Time Only data types as follow, create type Date from dateTime create ty…
6 replies
I am currently using a Start Date and and End Date as my parameters in a stored procedure. When I …
1 replies
Hi. How would I go about inserting multiple values into a table based on the results of the IN as b…
3 replies
Can i amend the following script to prompt a user for values when it is executed. Declare @FROM_DAT…
6 replies
Hi , Let say we have a heap table contains 10k records. as we know that according to sql server, St…
4 replies
I am currently need to format the contents of a column into a datetime. The format of the string is…
4 replies
I have the following sql statements to create an expected output. The output is what I would like t…
3 replies
Hi, It is possible to do something like this in SQL Server Triggers? If INSERT, do this; If UPDATE,…
2 replies
Create Table #Dim_Child (DW_Child_ID int, DOB DateTime) INSERT INTO #Dim_child SELECT 1 AS DW_Chil…
4 replies
Hello, I'd like to have total value of amount paid (PAID) iterated at every row level. For instance…
6 replies
I am sure this could be one of those questions you get in "how expert you are in sql" quizzes, but …
1 replies
Dear Experts , I have the following string SBR9D28.0178 The fourth character from the left stands f…
2 replies
Viewing 15 topics - 4,096 through 4,110 (of 12,230 total)
You must be logged in to create new topics.